Skip to content
Lesson 4/6

Days between dates, DATEDIF

Exercise 1 of 4

In C2, work out the number of days from start to end by subtracting.

About this lesson

Subtract one date from another to get the days between them, and use DATEDIF for whole months or years.

In this lesson

  1. In C2, work out the number of days from start to end by subtracting.
  2. Do the same in C2 with the DAYS function.
  3. In C2, work out the number of whole months from start to end.
  4. The start is a birthday. In C2, work out the age in whole years on the end date.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in C2 and press Enter to check.