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.
|