Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Statistical Functions
=DATEVALUE(20080223) converts text to date
Input the formula: =DATEVALUE("2008/02/23"). Press Enter to get the result.