Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

The DATEVALUE function converts a text string that looks like a date into a date serial number

Input the formula: =DATEVALUE("8/22/2007")