To turn a date into its calendar quarter — Q1, Q2, Q3, Q4 — divide the month number by 3 and round up. It’s a one-liner that drives quarterly reports and pivot groupings.
The example
Dates mapped to their quarter.
| A | B | |
|---|---|---|
| 1 | Date | Quarter |
| 2 | 2/14/2026 | 1 |
| 3 | 5/30/2026 | 2 |
| 4 | 11/02/2026 | 4 |
The formula
The quarter number in B2:
How it works
Month-number math gives the quarter:
MONTH(A2)extracts the month as 1–12.- Dividing by 3 puts each month into a third: months 1–3 give 0.33–1, months 4–6 give 1.33–2, etc.
ROUNDUP(…, 0)rounds those up to the whole quarter — 1, 2, 3, or 4.- For a label, wrap it:
="Q"&ROUNDUP(MONTH(A2)/3,0)gives “Q2.”
Include the year for multi-year data: =YEAR(A2)&"-Q"&ROUNDUP(MONTH(A2)/3,0) → “2026-Q2,” perfect for grouping in a PivotTable.
Try it: interactive demo
Pick a date; see its quarter.
Variations
Quarter label
Prefix with Q:
Year and quarter
Group across years:
Fiscal quarter (July start)
Shift the months before dividing:
Pitfalls & errors
This is the calendar quarter. Fiscal years starting in other months need the month shifted first (see the fiscal variation).
Text dates return #VALUE!. MONTH needs a real date; convert text dates first.
For totals by quarter, see Sum by Quarter. This formula labels a date; summing needs SUMIFS with date boundaries.
Practice workbook
Frequently asked questions
How do I get the quarter from a date in Excel?
How do I include the year with the quarter?
How do I get a fiscal quarter that doesn't start in January?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class