Date Functions
Intermediate

A quarter label from a date

MONTH divided by 3, rounded up, is the quarter.

Task:

The board reports by quarter. In B2:B7 label each transaction with its year and quarter, such as 2024-Q1.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of YEAR, MONTH, DAY

0/3

The same formula in the other shapes it takes at work.

  1. YEAR, MONTH, and DAY Functions

    Extract year, month, and day from dates using YEAR, MONTH, and DAY.

    Core
    Beginner
  2. A quarter label from a date

    MONTH divided by 3, rounded up, is the quarter.

    Intermediate
  3. Rebuild a date one year on

    Take a date apart, change one piece, put it back with DATE.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

7 rows × 2 columns6 cells you fill in
AB
1DateQuarter
21/31/2024
33/31/2024
44/1/2024
59/15/2024
612/2/2024
72/14/2025
What this exercise teachesMay contain the answer

Dividing the month by 3 and rounding up maps every month to its quarter in one step, with no lookup table. Including the year matters as soon as the data crosses a new year — Q1 2024 and Q1 2025 are not the same quarter.