mmb- fiscal year calculation--

  • Thread starter Thread starter mmb
  • Start date Start date
M

mmb

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.
 
With the below table in Sheet2ColA ColB..

With query date in cell A1 of Sheet1 try the below formula
=LOOKUP(A1,Sheet2!$A$2:$A$6,Sheet2!$B$2:$B$6)

If this post helps click Yes
 
Back
Top