| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get month number for fiscal year starting in Oct.
Does anyone know a formula that I can use to get the month number for a
fiscal year that starts Oct.? Thnaks, Tim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get month number for fiscal year starting in Oct.
Assuming date is in A1:
=IF(MONTH(A1)9,MONTH(A1)-9,MONTH(A1)+3) Hope this helps. -- John C "Tim" wrote: Does anyone know a formula that I can use to get the month number for a fiscal year that starts Oct.? Thnaks, Tim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get month number for fiscal year starting in Oct.
.... or =MOD(MONTH(A1)+2,12)+1
-- David Biddulph "John C" <johnc@stateofdenial wrote in message ... Assuming date is in A1: =IF(MONTH(A1)9,MONTH(A1)-9,MONTH(A1)+3) Hope this helps. -- John C "Tim" wrote: Does anyone know a formula that I can use to get the month number for a fiscal year that starts Oct.? Thnaks, Tim |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get month number for fiscal year starting in Oct.
Perfectly valid, I just tend to stay away from MOD function, too many times I
have used it and come up with values like 15.00000001. :) -- John C "David Biddulph" wrote: .... or =MOD(MONTH(A1)+2,12)+1 -- David Biddulph "John C" <johnc@stateofdenial wrote in message ... Assuming date is in A1: =IF(MONTH(A1)9,MONTH(A1)-9,MONTH(A1)+3) Hope this helps. -- John C "Tim" wrote: Does anyone know a formula that I can use to get the month number for a fiscal year that starts Oct.? Thnaks, Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define fiscal year | Excel Worksheet Functions | |||
| Can I convert a number(1-365) to a month and day of a 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 | |||
Linear Mode
