Level 2Dates, Part 2Practice, 3 min
A quarter column for reporting
The task
Finance reports by quarter. Column B already has a month key. In C2, fill the whole Quarter column with labels like 2026-Q3: the year, "-Q", then the month divided by 3 and rounded up.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Order date | Month | Quarter |
| 2 | Aug 14, 2026 | =TEXT(A2,"yyyy-mm") | |
| 3 | Jul 1, 2026 | =TEXT(A3,"yyyy-mm") | |
| 4 | Mar 31, 2026 | =TEXT(A4,"yyyy-mm") | |
| 5 | Oct 2, 2026 | =TEXT(A5,"yyyy-mm") | |
| 6 | Dec 18, 2026 | =TEXT(A6,"yyyy-mm") |