| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
fiscal year calculation
You need to add 1 to this calculation, as the OP wants both the start month
and the end month included in the range. Regards, Fred "tompl" wrote in message ... If the first date is in cell A1 and the second date is in cell A2 use this formula: =Datedif(A1, A2, "m") Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calendar year versus fiscal year | Excel Discussion (Misc queries) | |||
| mmb- fiscal year calculation-- | Excel Worksheet Functions | |||
| Define fiscal year | Excel Worksheet Functions | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| Fiscal Year Calculation | Excel Worksheet Functions | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
