=DATEVALUE("5-JUL") converts text to date : DATEVALUE « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =DATEVALUE("5-JUL"). Press Enter to get the result.
Input the formula: =DATEVALUE
21.18.DATEVALUE
21.18.1.DATEVALUE(date_text) converts a text to dateDATEVALUE(date_text) converts a text to date
21.18.2.=DATEVALUE("22-AUG-2008") converts text to date=DATEVALUE(
21.18.3.=DATEVALUE("2008/02/23") converts text to date=DATEVALUE(
21.18.4.=DATEVALUE("5-JUL") converts text to date=DATEVALUE(