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.

mmb- fiscal year calculation--
 

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
---------------
Jacob Skaria


"mmb" wrote:

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.

mmb- fiscal year calculation--
 

Jacob, you are great. Thank you so much. It works. Have a nice day.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"mmb" wrote:

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.