DATEDIF Function - Free Excel Practice Online

This free, interactive exercise teaches you DATEDIF Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Date Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising DATEDIF Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this DATEDIF Function lesson

1. The DATEDIF function (think "date difference") returns the number of days, months, or years between two dates. The first two arguments are the two dates. The third argument is "d", "m", or "y" depending on whether you want the difference in days, months, or years.To get the number of days between the two dates below, type:=DATEDIF(B1, B2, "d")
2. Use DATEDIF to get the number of months between the two dates. Hint: the third argument is "m".
3. Use DATEDIF to get the number of years between the two dates.
4. Below is a table of former employees at a company with their start dates and end dates. Use DATEDIF to get the number of days Betty worked for the company.
5. Use DATEDIF to get the number of months John worked for the company.
6. Use DATEDIF to get the number of years Carol worked for the company.
7. Use DATEDIF to get the number of days Mike worked for the company.
8. Use DATEDIF to find out how many days Janet started working after Betty started.
9. Use DATEDIF to find out how many months Janet started working after Betty started.
10. Use DATEDIF to find out how many years Janet started working after Betty started.

DATEDIF Function practice - FAQ