Tip Printed from ExcelTip.com

---

Calculating the Quarter Number


To calculate the quarter number for a calendar year:

Enter the formula:

=INT((MONTH(A2)-1)/3)+1

To calculate the quarter number for a fiscal year ending in September:

Enter the formula:

=MOD(CEILING(22+MONTH(A2)-9-1,3)/3,4)+1

Note: The number 9 in the formula represents the number of the last month of the fiscal year (September).