First hit on web search:
http://www.exceltip.com/st/Calculati..._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" wrote:

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.
--
Carol