The pickup log shows 4 pickups on January 15, 2025 and 7 on January 18, 2026. A chronological report needs separate rows for the two years.

See what By month does to the two dates

In Ulet’s Data → PivotTable dialog, put Date in Rows and Sum of Pickups in Values. For this example, By month groups the two Januaries together for 11 pickups. That can be useful for comparing seasons.

Month-only grouping combines two January records into a total of 11.

Illustrated seasonal grouping. Both source dates still carry their years.

Build a period key that includes the year

Use =TEXT(A2,"yyyy-mm") in a new Period column and fill down, keeping Date for date calculations. Include Period in the source range and use it in Rows with no extra month grouping. Verify 2025-01 shows 4 and 2026-01 shows 7.

The Period field shows 2025-01 and 2026-01 on separate pivot rows.

Illustrated timeline. Keep the original Date column.

Microsoft’s reference for grouping PivotTable dates