DATE
Returns the Excel serial number for the specified date. Handles month and day overflow (e.g. month=13 wraps to January of the next year).
| Category | Date |
| Syntax | DATE(year, month, day) |
Parameters
| Parameter | Required | Description |
|---|---|---|
year | Required | The year value. Years 0–1899 have 1900 added per Excel convention. |
month | Required | The month (1–12). Values outside this range overflow into adjacent months. |
day | Required | The day of the month. Values outside the month's range overflow into adjacent months. |
Example
DATE()
Auto-generated from the EngCanvas function registry.