Course
DATEDIF practice exercises
Five exercises, from counting full years of service to a staff table copied down with a fixed reference date. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Count full years of service
Emma started on the date in B2 and left on the date in C2. In D2, calculate her full years of service with DATEDIF.
| Employee | Start date | End date | Full years |
| Emma Clarke | 14/09/2015 | 31/03/2025 |