Date & Time
Modern
DATE
Builds a valid date from separate year, month and day numbers.
Available in All versions
Syntax
DATE(year, month, day)What it returns
A date.
Arguments
| Argument | Required | Description |
|---|---|---|
year |
Yes | The year (e.g. 2026). |
month |
Yes | The month number (1–12). |
day |
Yes | The day of the month (1–31). |
Example
2026Year
-06Month
-11Day
| A | |
|---|---|
| 1 | Date |
| 2 | 06/11/2026 |
DATE builds a real date from a year, a month and a day.
=DATE(2026, 6, 11)Important to know
Month/day values outside range roll over (month 13 = January of next year).
Years 0–1899 are added to 1900.