From a given date in a cell how can i get following things in different cell
(1) week of the month
(2)Financial year week (fiscal week)
(3) Quarter

e.g.
if A1=12 MAY 2009 , I want B1=2nd week ; C1=1st Quarter (financial year 1st
APR to 31st MAR)

or,
if A1=1 July 2008 , I want B1=1st week; C1= 2nd Quarter

Thanks in advance

I would create a lookup table of dates verses weeks on a different worksheet
and then look up the the dates to get the information you need. A formula is
possible but the 1st Friday of May is really in the last week of April.

"aditya" wrote:

From a given date in a cell how can i get following things in different cell
(1) week of the month
(2)Financial year week (fiscal week)
(3) Quarter

e.g.
if A1=12 MAY 2009 , I want B1=2nd week ; C1=1st Quarter (financial year 1st
APR to 31st MAR)

or,
if A1=1 July 2008 , I want B1=1st week; C1= 2nd Quarter

Thanks in advance