DATE
Date & timeExcel 2007Build a date from year, month and day numbers.
Syntax
DATE(year, month, day)
How it works
Month and day roll over: DATE(2026, 13, 1) is Jan 2027; DATE(2026, 3, 0) is the last day of February.
Examples
=DATE(2026, 4, 1)
→ 01-04-2026
=DATE(YEAR(A2), MONTH(A2)+1, 0)
→ month-end of A2
Related functions
More Date & time functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.