Converts a year, month and day into a date.
DATE(year, month, day)
year– The year component of the date.
month– The month component of the date.
day– The day component of the date.
DATEmust be numbers – if a string or a reference to a cell containing a string is provided, the #VALUE! error will be returned.
DATEwill silently recalculate numeric dates which fall outside of valid month or day ranges. For example,
DATE(1969,13,1), which specifies the illegal month 13, will create a date of 1 January 1970. Similarly,
DATE(1969,1,32), which specifies the non-existent 32nd day of January, will create a date of 1 February 1969.
DATEwill silently truncate decimal values that are input into the function; e.g. a month of 12.75 will be interpreted as 12.
Google Sheets uses the 1900 date system. The first date is 1 January 1900.
Between 0 and 1899, Google Sheets adds that value to 1900 to calculate the year. For example, DATE(119,2,1) will create a date of 1 February 2019.
For years 1900 to 9999, Google Sheets will use that value as the year. For example, DATE(2019,1,2) will create a date of 2 January 2019.
For years less than 0 or greater than 10,000, Google Sheets will return the #NUM! error value.
TO_DATE: Converts a provided number into a date.
TIME: Converts an hour, minute and second into a time.
N: Returns the argument provided as a number.
DATEVALUE: Converts a provided date string in a known format into a date value.