ExcelHeroThe DATE function
Builds a date from year, month and day.
In German Excel: DATUM
How to write it
=DATE(year, month, day)- year
- The year.
- month
- The month, 1–12.
- day
- The day.
💡 Month 13 rolls into next year: DATE(2025,13,1) is Jan 1, 2026.
Try it
Build the date from the year, month and day.
A
B
1
Year
2025
2
Month
12
3
Day
24
4
Date
=DATE(year, month, day).