DATE

  • Updated

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 C5C6 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.