Excel DATEVALUE Function

Excel DATEVALUE Function

Sponsored Link


Convert a date in text format to a valid date

Return value 

A serial number that represents a particular date in Excel.


=DATEVALUE (date_text)


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

Sponsored Link

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas