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