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/1/1970. Similarly,
DATE(1969,1,32), which specifies the non-existent 32nd day of January, will create a date of 2/1/1969.
DATEwill silently truncate decimal values input into the function, e.g. a month of 12.75 will be interpreted as 12.
TO_DATE: Converts a provided number to 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 to a date value.
DATE accepts both string and cell-reference values, also handles the numbers that fall outside of the valid month or day range.