G Guest Jan 25, 2006 #1 Hi I am Tanuja i need to know what week is it in a month not in a year is it possible
B Bob Phillips Jan 25, 2006 #2 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)
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)
