Skip to main content


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

JavaScript errors detected

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

If this problem persists, please contact our support.