DATEVALUE


Definition of DATEVALUE

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

Sample Usage

DATEVALUE("1969-7-20")

DATEVALUE("7/20/1969")

DATEVALUE(A2)

Syntax

DATEVALUE(date_string)
  • 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.

Notes

  • 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:

DATEVALUE1.png

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

DATEVALUE2.png

DATEVALUE3.png

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

DATEVALUE4.png