Date & Time
Determine Fiscal Quarter
Determine which fiscal quarter a date falls in. Standard fiscal quarters: Q1 (Jan-Mar), Q2 (Apr-Jun), Q3 (Jul-Sep), Q4 (Oct-Dec).
Excel Formula
="Q"&ROUNDUP(MONTH(A2)/3,0)Step-by-Step Explanation
1
MONTH(A2) extracts the month number (1-12)
2
Dividing by 3 groups months into quarters
3
ROUNDUP rounds up to get the quarter number
4
Concatenating with "Q" gives Q1, Q2, Q3, or Q4
5
January-March → Q1, April-June → Q2, etc.
Example
| Date (A) | Quarter (B) |
|---|---|
| 2/15/2026 | Q1 |
| 5/20/2026 | Q2 |
| 9/1/2026 | Q3 |
| 11/30/2026 | Q4 |
Result: =\"Q\"&ROUNDUP(MONTH(A2)/3,0) → Q1
Common Variations
Quarter number only
=ROUNDUP(MONTH(A2)/3,0)Returns 1, 2, 3, or 4
Fiscal year starting April
="Q"&ROUNDUP(MOD(MONTH(A2)+8,12)/3,0)For April-March fiscal year
Quarter with year
="Q"&ROUNDUP(MONTH(A2)/3,0)&" "&YEAR(A2)Returns Q1 2026
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →