Example
Sponsored Link
Purpose
Convert a date in text format to a valid date
Return value
A serial number that represents a particular date in Excel.
Syntax
=DATEVALUE (date_text)
Arguments
- date_text – A valid date in text format.
Usage notes
If date_text is a cell address, the value of the cell must be text. If date_text is entered directly into the formula it must be enclosed in quotes.
Will return a #VALUE error if date_text refers to a cell that does not contain a date formatted as text.