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:
- start_date – start date in Date format.
- end_date – end date in Date format.
- 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 |
Examples:
=DATEDIF(D2,D3,"D")