| 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")
