Thread: Quarterly Formula
View Single Post
  #3  
Old April 13th, 2010, 06:20 PM posted to microsoft.public.excel.newusers
Caroline
external usenet poster
  
Posts: 234
Default Quarterly Formula
Thank you very much JLatham!
--
Carol


"JLatham" wrote:

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