Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

DATEVALUE(date_text) converts a text to date

Input the formula: =DATEVALUE("8/22/2008"). Press Enter to get the result.