Thread
:
Quarterly Formula
View Single Post
#
3
April 13th, 2010, 06:20 PM posted to microsoft.public.excel.newusers
Caroline
external usenet poster
Posts: 234
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
Caroline
View Public Profile
View message headers
Find all posts by Caroline
Find all threads started by Caroline