If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|