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

One way..

=INT(DATEDIF(DATE(YEAR(A1),MONTH(A1),1),A1,"d")/7+1)

If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

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

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

"Jacob Skaria" wrote in message
...
One way..

=INT(DATEDIF(DATE(YEAR(A1),MONTH(A1),1),A1,"d")/7+1)

If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

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

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
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"Jacob Skaria" wrote in message
...
One way..

=INT(DATEDIF(DATE(YEAR(A1),MONTH(A1),1),A1,"d")/7+1)

If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

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