Skip to main content


Definition of DATE

Converts a provided year, month, and day into a date.

Sample Usage




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.


  • Inputs to DATE must be numbers - if a string or a reference to a cell containing a string is provided, the #VALUE! error will be returned.
  • DATE will 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.
  • DATE will silently truncate decimal values input into the function, e.g. a month of 12.75 will be interpreted as 12.

See Also

TO_DATE: Converts a provided number to a date.

TIME: Converts a provided 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.

In order to use the DATE formula, start with your edited Excellentable:

Then type in the DATE formula in the area you would like to display the outcome:

By adding the values you would like to calculate the DATE formula for, Excellentable will generate the outcome:


User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.