Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing dates to a fiscal year | Excel Discussion (Misc queries) | |||
Define fiscal year | Excel Worksheet Functions | |||
Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
Birthdate as fiscal year | Excel Discussion (Misc queries) | |||
Fiscal Year Calculation | Excel Worksheet Functions |