Exercises / Dates and deadlines · 2 of 10
How many days late?
Because dates are numbers, subtracting one from another gives the days between them. Later date minus earlier date gives a positive number.
Your taskIn D2, work out how many days after the due date (B2) each invoice was paid (C2). Early payments come out negative. It will be copied down to D7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Invoice | Due | Paid | Days late |
| 2 | INV-101 | 15 Feb 2026 | 20 Feb 2026 | |
| 3 | INV-102 | 28 Feb 2026 | 25 Feb 2026 | |
| 4 | INV-103 | 10 Mar 2026 | 2 Apr 2026 | |
| 5 | INV-104 | 15 Mar 2026 | 15 Mar 2026 | |
| 6 | INV-105 | 31 Mar 2026 | 4 May 2026 | |
| 7 | INV-106 | 15 Apr 2026 | 12 Apr 2026 |