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.

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.

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



