Definition of DATEVALUE
Converts a provided date string in a known format to a date value.
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.
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: