ExcelBanter - Quarterly Formula

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Quarterly Formula (https://www.excelbanter.com/new-users-excel/261231-quarterly-formula.html)

Caroline

Quarterly Formula

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

JLatham

Quarterly Formula

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

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

All times are GMT +1. The time now is 08:32 PM.