View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mmb mmb is offline
external usenet poster
 
Posts: 17
Default mmb- fiscal year calculation--

I have this data and I need to convert specific dates into FY Q1 tru 4 base
on the below FY

FY calendar start on the following:
start date: FY:
10/27/2008 Q109
1/26/2009 Q209
4/27/2009 Q309
7/27/2009 Q409
10/26/2009 Q110

If i have a date date 1-25-09 (Q1 09) and date 1-26-09 (Q2 09) -- what will
be my formula to show the FY-- Q1 09 and Q2 09? Can anyone help. Thanks alot
in advance.