How do you define your weeks?
Does week 1 run from 1st to 7th of March, or is it dependent on the day of
the week?
If the former, perhaps =INT((A1-DATE(YEAR(A1)-(MONTH(A1)<4),4,1))/7)+1
--
David Biddulph

"aditya" wrote in message
...
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