DATE (Year, Month, Day) DATE (Year; Month; Day)
Year
Number Number
The year, which is taken literally.
Month
Number Number
The month (1 through 12).
Day
Number Number
The day (1 through 31).
Returns
Temporal Temporal
A date representing the given year, month and day.
Returns a date representing the given year, month and day. A month or day outside its natural range carries over into the neighboring components.
Examples
DATE (2013, 1, 1)
DATE (2013; 1; 1)
Returns a date representing January 1, 2013.
DATE (2024, 13, 1)
DATE (2024; 13; 1)
Returns a date representing January 1, 2025, as the 13th month of 2024 is the first month of 2025.
DATE ({ 1981, 2021 }, 5, 1)
DATE ({ 1981; 2021 }; 5; 1)
Returns an array of dates representing May 1, 1981 and May 1, 2021.
FORMAT.DATE ( DATE (1981, 11, 14))
FORMAT.DATE ( DATE (1981; 11; 14))
Returns "11/14/1981" if the configured locale is US English.