Confident Cells

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.

ABCDEFGH
1EmployeeRequestedDeadlineSent inDays late
2Grace08/09/202620/09/20260Sent in late4
3Tom08/09/202625/09/20263
4Priya10/09/202622/09/20260
5Marek10/09/202601/10/20267Project starts03/09/2026
6Nia15/09/202629/09/20260Project ends23/10/2026
7Ollie15/09/202602/10/20263Weekdays in project37
8Lucy17/09/202630/09/20260
9Hamza17/09/202606/10/20265Date of birth14/08/1988
10Review date15/05/2027
11Age on review date38

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

ABCDEF
1TaskStartDays allowedDueDoneDays late
2Report02/03/20261012/03/202616/03/2026
3Survey02/03/20262123/03/202620/03/2026
  1. =B2+C2 in D2. A date plus a number is that many days later: 2 March + 10 days = 12 March.
  2. =E2-D2 in F2. One date minus another gives the days between them: the report came in 4 days late.
  3. =E2-D2 in 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

AB
1Dates
2Start02/03/2026
3End13/03/2026
4Weekdays
5Born15/08/1990
6Age at start
7Six months on
  1. =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.
  2. =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.
  3. =EDATE(B2,6) in B7. EDATE(date, months) moves a date on by whole months: 2 September 2026.

What you'll practise

  1. Each report is due two weeks after it's requested. In C2, work out each deadline.
  2. In E2, work out how many days late each piece was, showing 0 if it was on time.
  3. In H2, count how many reports were sent in late.
  4. In H7, count the weekdays from the start of the project (H5) to its end (H6).
  5. In H11, work out the employee's age in whole years on the review date.
  6. 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.