What is the syntax of DATEVALUE Function in Excel?

The Excel DATEVALUE function converts a date represented as a text string into a valid Excel date. For example, the formula =DATEVALUE(“3/10/1975”) returns a serial number (27463) in the Excel date system that represents March 10, 1975. Proper Excel dates are more useful than text dates since they can be directly manipulated with formulas and pivot tables .

  • Purpose: Convert a date in text format to a valid date
  • Return value: A valid Excel time as a serial number


=DATEVALUE (date_text)


To illustrate how the DATEVALUE function works, the formula below shows how the text “3/10/1975” is converted to the date serial number 27463 by DATEVALUE:

=DATEVALUE("3/10/1975") // returns 27463