Quarterly Formula

[Caroline]

Is there a formula to obtain a total for each quarter which excludes
including the year? Thus avoiding having to change to year on a yearly
basis. Your help would be appreciated.

 

[JLatham]

First hit on web search
http://www.exceltip.com/st/Calculating_the_Quarter_Number_for_Calendar_and_Fiscal_Year/932.html
quarter based on calendar year (with date in A2)
=INT((MONTH(A2)-1)/3)+1
quarter based on FY starting in September, again w/date in A2:
=MOD(CEILING(22+MONTH(A2)-9-1,3)/3,4)+1

 

[Caroline]

Thank you very much JLatham!
--
Carol

First hit on web search:
http://www.exceltip.com/st/Calculating_the_Quarter_Number_for_Calendar_and_Fiscal_Year/932.html
quarter based on calendar year (with date in A2)
=INT((MONTH(A2)-1)/3)+1
quarter based on FY starting in September, again w/date in A2:
=MOD(CEILING(22+MONTH(A2)-9-1,3)/3,4)+1