Excel + Google Sheets · Quarter
Any date into a quarter
Month divided by 3, rounded up, gives the quarter.
The formula
="Q" & ROUNDUP(MONTH(A2) / 3, 0)What each part means
MONTH(A2)Month 1–12/ 3, rounded upQuarter 1–4"Q" &Adds the letter
Example
| A | B | |
|---|---|---|
| 1 | Date | Quarter |
| 2 | 2026-02-14 | |
| 3 | 2026-05-03 | |
| 4 | 2026-08-21 | |
| 5 | 2026-11-02 |
| A | B | |
|---|---|---|
| 1 | Date | Quarter |
| 2 | 2026-02-14 | Q1 |
| 3 | 2026-05-03 | Q2 |
| 4 | 2026-08-21 | Q3 |
| 5 | 2026-11-02 | Q4 |
Step by step
- Click cell B2.
- Type the formula:
="Q" & ROUNDUP(MONTH(A2) / 3, 0) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)