Definition of DATEVALUE

Converts a provided date string in a known format to a date value.

Sample Usage





  • date_string - The string representing the date.
    • Understood formats include any date format which is normally autoconverted when entered, without quotation marks, directly into a cell. Understood formats may depend on region and language settings.


  • The input to DATEVALUE must be a string - if a number or cell reference to a cell containing a number is provided, the #VALUE! error will be returned.
  • If providing an explicit string input to DATEVALUE rather than a cell reference, surrounding quotation marks are required.
  • To quickly ensure that the desired date format is understood, type an example of it into an empty cell, without quotation marks.

See Also

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

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

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

Then type in the DATEVALUE Formula in the area you would like to display the outcome:

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



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