FUNCTION CATALOGUE / DATE & TIME
DATE Excel function
Creates a date from year, month, and day.
Correct sentence to use
Create a date for [year]-[month]-[day].
Modify this query in PlainFormula →Example formula
=DATE(2026,10,29)
Creates an Excel date serial.
Syntax
DATE(year, month, day)
Argument signature: year, month, day
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.