Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Fixed as-of dates. Because dates are numbers, later minus earlier gives the days between them. For reports, put the as-of date in its own cell and lock it with $ in your formulas. A live today function would change every result tomorrow, so the report could never be checked again.
=$H$1-D2 days from a refund date in D2 to the date in H1
The year-end review looks at how long it has been since key accounts last placed a completed order. The report date is fixed in B1, so the numbers don’t change when someone opens the file next week.
In C4:C11, return the number of days between each customer’s last order date in column B and the report date in B1. Point at B1 rather than typing the date.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Report date | 2025-12-31 | ||||||
| 2 | ||||||||
| 3 | Customer | Last order | Days since | |||||
| 4 | Harbor & Pine Hotels | 2025-06-30 | ||||||
| 5 | Lakeside Motors | 2025-08-28 | ||||||
| 6 | Bright Pharmacy | 2025-10-14 | ||||||
| 7 | Willow Logistics | 2025-10-21 | ||||||
| 8 | Harbor Realty | 2025-11-28 | ||||||
| 9 | Orchard Clinic | 2025-12-12 | ||||||
| 10 | Beacon Accounting | 2025-12-17 | ||||||
| 11 | Summit Realty | 2025-12-22 | ||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe