EDATE
Returns the serial number of the date a given number of months before or after a start date, keeping the day-of-month (clamped to the target month length).
| Category | Date |
| Syntax | EDATE(start_date, months) |
Parameters
| Parameter | Required | Description |
|---|---|---|
start_date | Required | The Excel date serial number to start from. |
months | Required | Months to add (negative for earlier dates). |
Example
EDATE()
Auto-generated from the EngCanvas function registry.