Hi Aditya

In B1 try

=ROUND(DATEDIF(DATE(IF(MONTH(A1)<4,YEAR(A1)-1,YEAR(A1)),4,1),A1,"d")/7,0)+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 financial year in
cell B1.
note: financial year 1st APR to 31st March.

e.g.
A1=02-APR 09 B1=1st Week
A2=28 Mar 09 B2=52nd Week