Tip Printed from ExcelTip.com

---

Calculating the Quarter Number for Calendar and Fiscal Year


Problem:

Calculating the quarter number corresponding with each of the dates listed in column A.

Solution:

To calculate the quarter number based on a calendar year, use the INT and MONTH functions in the following formula:
=INT((MONTH(A2)-1)/3)+1
To calculate the quarter number based on a fiscal year (starting in September), use the MOD, CEILING, and MONTH functions as shown in the following formula:
=MOD(CEILING(22+MONTH(A2)-9-1,3)/3,4)+1