simple week entry

[aditya]

if in cell A1 date is given, how can i do week entry of the month in
cell B1/B2.


e.g.
A1=2-APR 09 B1=1st Week
A2=28- Mar 09 B2=4th Week
A3=9-Feb 09 B3= 2nd week

 

[David Biddulph]

Or, presumably, =INT((A1-DATE(YEAR(A1),MONTH(A1),1))/7)+1 ?
Usual questions as to how the OP wanted the week defined. If week 1 runs
from 1st to 8th, Jacob's formula or mine would do the job; if dependent on
day of the week, it would need changing.

 

[David Biddulph]

Looking again at Jacob's formula, and at my version removing the DATEDIF, I
realise that they reduce to =INT((DAY(A1)-1)/7)+1