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