The DATEVALUE function converts a text string that looks like a date into a date serial number : DateValue « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. DateValue
Input the formula: =DATEVALUE("8/22/2007")
15.3.DateValue
15.3.1.The DATEVALUE function converts a text string that looks like a date into a date serial number