Thread: How to get month number for fiscal year starting in Oct.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default 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
Reply With QuoteReply With Quote