Dates · source records · Pivot summaries
Filter dates. Compare weekdays.
Follow the real cells, then unlock the same worksheet to try your own dates and amounts.
Teaching · read-only · Report!A1
Step 1 / 6Read a real source date
Preparing the dated worksheet…
Check the current source and parameters, or explicitly repair edited calculation helpers.
Retained records: of 12. Grand sum: · previous valid calculation
Before and After exclude the comparison day. Between includes both boundaries. Changing a condition retains every original record. Edit B2 with a real date formula such as =DATE(2024,2,29), or a whole Excel date serial; text dates are rejected.
Inspect contributing original records
| Record | Date | Category | Amount |
|---|---|---|---|
| W01 | 2023-12-31 | Cedar | 120 |
| W02 | 2024-01-01 | Cedar | 80 |
| W03 | 2024-02-28 | Lumen | 0 |
| W04 | 2024-02-29 | Cedar | -15 |
| W05 | 2024-02-29 | Harbor | 40 |
| W06 | 2024-03-01 | Lumen | 160 |
| W07 | 2024-03-02 | Cedar | 30 |
| W08 | 2024-03-03 | Harbor | 90 |
| W09 | 2024-03-04 | Cedar | -5 |
| W10 | 2024-12-31 | Lumen | 200 |
| W11 | 2025-01-01 | Cedar | 60 |
| W12 | 2025-01-05 | Harbor | 100 |
Average is recalculated from these original records, including zero and negative amounts. An empty population has no Average.
Current copies preserve the working sheet. The native file carries all source records, a Weekday helper and an Included report filter. These helpers express the date condition; Excel’s native date-grouping command has no weekday interval.