DATEDIF
Returns the difference between two dates in the requested unit. Units: "D" days, "M" complete months, "Y" complete years, "MD" days ignoring months/years, "YM" months ignoring years, "YD" days ignoring years. Requires start ≤ end.
| Category | Date |
| Syntax | DATEDIF(start_date, end_date, unit) |
Parameters
| Parameter | Required | Description |
|---|---|---|
start_date | Required | The earlier Excel date serial number. |
end_date | Required | The later Excel date serial number. |
unit | Required | A string: "D", "M", "Y", "MD", "YM", or "YD". |
Example
DATEDIF()
Auto-generated from the EngCanvas function registry.