The DATEVALUE function is meant to convert a date represented as atext stringinto avalid Excel date.
The DATEVALUE function takes just one argument, calleddate_text.
Ifdate_textis a cell address, the value of the cell must be text.
Ifdate_textis entered directly into the formula it must be enclosed in quotes.
A datenumber formatmust be applied to display this number as a date.
Notice that Excel makes certain assumptions about missing day and year values.
Alternative formula
Notice that the DATEVALUE formula in C15 fails with a #VALUE!
error, because cell B15 already contains a valid date.
This is a limitation of the DATEVALUE function.
If Excel can parse the text into a proper date it will return a valid date serial number.
If the date is already a valid Excel date (i.e.
a serial number), adding zero will have no effect, and generate no error.
a number, date, or time format) into a numeric value.
Normally, the VALUE function is not needed in Excel, because Excel automatically converts text to numeric values.
This function can be used to convert locale-specific values into locale-independent values.
