| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to determine Fiscal Year
I have the customers start date in Column A, i.e. 4/1/2007.
In Column B I would like to determine what fiscal year they started in. For example: If their start date is between 3/1/08 - 2/28/09, I would like the result of Column B to be FY08/09. If their start date is between 3/1/07 - 2/28/08, I would like the result of Column B to be FY07/08. Is there a formula for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define fiscal year | Excel Worksheet Functions | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| Formula for Fiscal Year Conditional Formatting | Excel Discussion (Misc queries) | |||
| Fiscal Year Calculation | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Threaded Mode
