Thread: How do I convert a specific date to a fiscal quarter ?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default How do I convert a specific date to a fiscal quarter ?
January-March is qtr 1
April-June is qtr 2
July-September is qtr 3
October-December is qtr 4

="FY"&YEAR(A1)&"-Q"&INT(1+MOD(MONTH(A1)-1,12)/3)

Maybe I'm missing something, but why do you need the MOD function in the
calculation for the quarter?

="FY"&YEAR(A1)&"-Q"&(1+INT((MONTH(A1)-1)/3))

Rick

Reply With QuoteReply With Quote