DATEDIF

Definition: DATEDIF is a function that returns the difference between two dates in months, days, or years.

Syntax: =DATEDIF(start_date, end_date, unit)

Situation: This formula is suitable when you need to calculate the difference between two dates in months, days, or years.

Example: If you have a start date January 1, 2021 and an end date December 31, 2021, the number of days between the two dates can be found using the formula =DATEDIF(“1/1/2021”, “12/31/2021”, “d”), which returns 364.