close
Hi I am Tanuja i need to know what week is it in a month not in a year is it
possible
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)
quot;Tanuja Kandulaquot; lt;Tanuja gt; wrote in message
...
gt; Hi I am Tanuja i need to know what week is it in a month not in a year is
it
gt; possible
全站熱搜