DATEDIF
Category: DateTime Function.
Description: Returns the number of days, months, or years between two dates.
Syntax: DATEDIF(start_date, end_date, interval_type)
Start_date is the first date of the period.
End_date is the last date of the period.
Dates can be entered as text strings within quotation marks, as serial numbers, or as the results of other formulas or functions.
Interval_type is a case-insensitive string that specifies the type of the returned information:
-
"M" - Complete calendar months between dates.
-
"D" - Number of days between dates.
-
"Y" - Complete calendar years between dates.
-
"YM" - Complete calendar months between dates as if they were of the same year.
-
"YD" - Complete calendar days between dates as if they were of the same year.
-
"MD" - Complete calendar days between dates as if they were of the same month and year.