DATE function
DATE(Year, Month,
Day) DATE(Year; Month;
Day)
Year
Number or { Number }
The year.
Month
Number or { Number }
The month (1 through 12).
Day
Number or { Number }
The day (1 through 31).
Returns
Number or { Number }
A sequential serial number representing the given year, month and day.
Returns a sequential serial number representing the given year, month and day.
The value returned from this function can be set as the initial value displayed by a date and time field.
Examples
DATE(2013, 1,
1)DATE(2013; 1; 1)
Returns a sequential serial number representing January 1, 2013.
DATE({ 1981, 2021 },
5, 1)DATE({ 1981;
2021 }; 5; 1)
Returns an array of sequential serial numbers representing May 1, 1981 and May 1, 2021.
FORMATDATE(DATE(1981, 11,
14))FORMATDATE(DATE(1981; 11;
14))
Returns "11/14/81" if the language of the app is set to US English.