Exercises / Dates and deadlines · 3 of 10
Age in whole years
DATEDIF(start, end, unit) counts complete years ("y"), months ("m") or days ("d") between two dates. Dividing days by 365 drifts because of leap years and gives fractions.
Your taskIn C2, use DATEDIF to work out how many complete years old each person is on the date in F1. It will be copied down to C7.
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 | E | F |
|---|---|---|---|---|---|---|
| 1 | Name | Born | Age | As of | 9 Nov 2026 | |
| 2 | Ana | 21 Mar 1994 | ||||
| 3 | Ben | 9 Nov 2001 | ||||
| 4 | Cara | 1 Dec 1988 | ||||
| 5 | Dino | 10 Nov 1999 | ||||
| 6 | Ema | 29 Feb 2004 | ||||
| 7 | Femi | 14 Jul 1975 |