Converts numerical values for year, month, day into a date.
Sample Usage
DATE(2020,2,1)
DATE(C5,C6,C7)
Syntax
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.
Examples
DATE(2020,2,1) returns the date string 2/1/2020.
DATE(C5,C6,C7) returns the date string using the values contained in C5, C6 and C7.
Notes
- The arguments must be numbers - if a string or a reference to a cell containing a string is provided, the #VALUE! error will be returned. The DATEVALUE function accepts strings as inputs.
- DATE recalculates numeric values which fall outside of valid ranges. For example, DATE(2019,13,1) returns a date of 1/1/2020.
- Decimal inputs will be truncated.