DATE
Builds a date from a year, month and day.
How it’s written
DATE(year, month, day)Example
| A | B | C | |
|---|---|---|---|
| 1 | Year | Month | Day |
| 2 | 2,026 | 3 | 15 |
=DATE(A2,B2,C2)Result: 46,096
Returns the date, stored as the number 46096. Format the cell as a date to see March 15, 2026.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
A month of 13 rolls into January of the next year, which is sometimes useful.
Practice it properly
Taking dates apart gives you real tasks, with your formulas tested on data you haven’t seen.