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

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

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: