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:
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:
Error rendering macro 'excellentable' : Page loading timed out