Weeks, months and quarters in reports

Label each row with its week number, month and quarter, then count and total the rows between two dates typed into cells. Intermediate · 6 min · WEEKNUM, TEXT "mmm", Quarters, Date ranges in COUNTIFS / SUMIFS

Reports rarely group by exact date. People ask about week 14, March or Q2. A few short formulas turn a date column into those labels:

WEEKNUM(date, 2): the week of the year, with weeks starting on Monday
TEXT(date, "mmm"): the short month name
"Q"&ROUNDUP(MONTH(date)/3, 0): the quarter

Then you'll count and total the jobs between two dates kept in cells. The sheet is a mobile bike mechanic's job log for 2026.

Steps

In D2:D11, find the week number of each job with =WEEKNUM(A2, 2). The 2 starts each week on Monday, just like the 2 in WEEKDAY.
In E2:E11, label each job with its month's short name using =TEXT(A2, "mmm").
A quarter is three months, so the quarter is the month divided by 3, rounded up. In F2:F11, build labels like Q1 with ="Q"&ROUNDUP(MONTH(A2)/3, 0).
The spring offer ran from the date in I2 to the date in I3. In I4, use COUNTIFS to count the jobs dated on or after I2 and on or before I3.
In I5, total the prices of the same jobs with SUMIFS. The price column comes first, then the same two date conditions.

Remember

WEEKNUM(date, 2) numbers the weeks of the year, starting on Monday.
TEXT(date, "mmm") makes a month label; "Q"&ROUNDUP(MONTH(date)/3, 0) makes a quarter label.
For a date range, test the same column twice: ">="&start and "<="&end.
Keep the start and end dates in cells so the report re-runs when you type new ones.

Previous: Pay and overtime · Next: RANK, LARGE and SMALL