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 wrote in message
...
Hi I am Tanuja i need to know what week is it in a month not in a year is
it
possible