You are here:


Function name DATEDIF
Type Date
Arguments – start_date
– end_date
– interval
Syntax =DATEDIF(start_date, end_date, interval)
Description Returns the difference between two date values in years, months, or days.

The Arguments description:

  1. start_date – start date in Date format.
  2. end_date – end date in Date format.
  3. interval – interval type to be used (years, months or days). See below.
Interval Result
“Y” Difference in complete years
“M” Difference in complete months
“D” Difference in days
“MD” Difference in days, ignoring months and years
“YM” Difference in months, ignoring days and years
“YD” Difference in days, ignoring years



DATEDIF function