The DATE function
Builds a date from a year, month and day. Months and days outside the normal range roll over: month 14 is February next year.
Syntax
DATE(year, month, day)- year
- The year, such as 2024.
- month
- The month, 1 to 12 (other values roll over).
- day
- The day of the month.
Examples
B1=DATE(2024,3,15)-DATE(2024,1,1)
| A | B | |
|---|---|---|
| 1 | 74 |
B1=MONTH(DATE(2024,14,1))
| A | B | |
|---|---|---|
| 1 | 2 |