| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fiscal year calsulations for past to future dates.
A date entered in A1 for example is 8/12/2004 that would be fiscal year 2005,
I am looking for a formula that will auto calculate what the correct fiscal year is based on the date given and put it in B1. I need to go back to 2001 and would like to go as far forward as 2015. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Dates Within Fiscal Year | Excel Discussion (Misc queries) | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| Pivot Table: Change dates to fiscal year | Excel Worksheet Functions | |||
| Pivot Table: Change dates to fiscal year | Excel Discussion (Misc queries) | |||
| How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel | |||
Threaded Mode
