weeknum of the month Tanuja Kandula 25.01.2006 09:29:02 Hi I am Tanuja i need to know what week is it in a month not in a year is it possible

Re: weeknum of the month "Bob Phillips" <bob.phillips[ at ]notheretiscali.co.uk> 25.01.2006 11:28:02 Assuming that the date is in A1, and week 1 starts on the 1st (not 1st Sun/Mon say), then =INT(DAY(A1)/7)+1 -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Tanuja Kandula" <Tanuja Kandula[ at ]discussions.microsoft.com> wrote in message news:25DAA962-7944-4ABF-8472-D1AD2F0F707A[ at ]microsoft.com... [Quoted Text] > Hi I am Tanuja i need to know what week is it in a month not in a year is it > possible