Dates and deadlines: practice exercises
Date arithmetic, NETWORKDAYS, DATEDIF. 6 exercises on real-looking data, each marked the moment you press Check. The first exercise is below to try now; the full lesson is part of Pro.
Your turn
Each report is due two weeks after it's requested. In C2, work out each deadline.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Employee | Requested | Deadline | Sent in | Days late | |||
| 2 | Grace | 08/09/2026 | 20/09/2026 | 0 | Sent in late | 4 | ||
| 3 | Tom | 08/09/2026 | 25/09/2026 | 3 | ||||
| 4 | Priya | 10/09/2026 | 22/09/2026 | 0 | ||||
| 5 | Marek | 10/09/2026 | 01/10/2026 | 7 | Project starts | 03/09/2026 | ||
| 6 | Nia | 15/09/2026 | 29/09/2026 | 0 | Project ends | 23/10/2026 | ||
| 7 | Ollie | 15/09/2026 | 02/10/2026 | 3 | Weekdays in project | 37 | ||
| 8 | Lucy | 17/09/2026 | 30/09/2026 | 0 | ||||
| 9 | Hamza | 17/09/2026 | 06/10/2026 | 5 | Date of birth | 14/08/1988 | ||
| 10 | Review date | 15/05/2027 | ||||||
| 11 | Age on review date | 38 |
How it works
Excel stores dates as numbers of days, so you can add and subtract them: a date + 14 is two weeks later, and one date minus another gives the days between them.
NETWORKDAYS(start, end) counts weekdays. DATEDIF(start, end, "Y") gives whole years between two dates, for example an age.
=B2+C2 =E2-D2 =NETWORKDAYS(B2,B3) =DATEDIF(B5,B2,"Y") =EDATE(B2,6)
Dates are numbers
A spreadsheet stores a date as a number of days, so you can do sums with dates.
- A date + 14 is two weeks later.
- One date minus another is the number of days between them.
- A few functions do the harder jobs: weekdays, whole years and whole months.
Worked example: adding and subtracting
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Task | Start | Days allowed | Due | Done | Days late |
| 2 | Report | 02/03/2026 | 10 | 12/03/2026 | 16/03/2026 | |
| 3 | Survey | 02/03/2026 | 21 | 23/03/2026 | 20/03/2026 |
=B2+C2in D2. A date plus a number is that many days later: 2 March + 10 days = 12 March.=E2-D2in F2. One date minus another gives the days between them: the report came in 4 days late.=E2-D2in F2. The survey was early, so it comes out negative: −3.MAX(0, …)round it would turn that into 0.
Worked example: weekdays, years and months
| A | B | |
|---|---|---|
| 1 | Dates | |
| 2 | Start | 02/03/2026 |
| 3 | End | 13/03/2026 |
| 4 | Weekdays | |
| 5 | Born | 15/08/1990 |
| 6 | Age at start | |
| 7 | Six months on |
=NETWORKDAYS(B2,B3)in B4.NETWORKDAYS(start, end)counts the weekdays from one date to another, including both ends: 2 to 13 March is 10.=DATEDIF(B5,B2,"Y")in B6.DATEDIF(earlier, later, "Y")gives the whole years between two dates: on 2 March 2026, someone born on 15 August 1990 is 35. Excel doesn't suggest DATEDIF as you type, but it works.=EDATE(B2,6)in B7.EDATE(date, months)moves a date on by whole months: 2 September 2026.
What you'll practise
- Each report is due two weeks after it's requested. In C2, work out each deadline.
- In E2, work out how many days late each piece was, showing 0 if it was on time.
- In H2, count how many reports were sent in late.
- In H7, count the weekdays from the start of the project (H5) to its end (H6).
- In H11, work out the employee's age in whole years on the review date.
- Each contract runs for the number of months in column C. In D2, work out the date it's due for renewal: the start date plus that many months.