Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

=DATEVALUE(5-JUL) converts text to date

Input the formula: =DATEVALUE("5-JUL"). Press Enter to get the result.