The summary needs a year and calendar quarter for each date. Include the year so Q1 records from different years stay separate.

Round the month number divided by three up

Put March 31, 2026 and April 1, 2026 in A2:A3 as dates. Enter this in B2 and fill down.

=YEAR(A2)&" Q"&ROUNDUP(MONTH(A2)/3,0)

Expect 2026 Q1 and 2026 Q2. March is month 3 and April is month 4.

March 31 and April 1 fall on opposite sides of a quarter boundary.

Illustrated calendar grouping. Start with real dates.

Check the rollover into January

Try December 31, 2026 and January 1, 2027. Expect 2026 Q4 and 2027 Q1. This formula uses the January–March calendar quarter. If your reporting year starts in another month, use its fiscal calendar rule. Review blank or text inputs before grouping them.

December 31 and January 1 keep their distinct reporting years.

Illustrated year boundary. Check whether your report uses a fiscal calendar.

Microsoft’s MONTH function reference