How to get month number for fiscal year starting in Oct.

[Tim]

Does anyone know a formula that I can use to get the month number for a
fiscal year that starts Oct.?

Thnaks, Tim

 

[John C]

Assuming date is in A1:
=IF(MONTH(A1)>9,MONTH(A1)-9,MONTH(A1)+3)

Hope this helps.

 

[David Biddulph]

.... or =MOD(MONTH(A1)+2,12)+1

 

[John C]

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.