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

1. Microsoft Office Excel 2007 Tutorial
2. Statistical functions
3. DATEVALUE

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

21.18.DATEVALUE
	21.18.1.	DATEVALUE(date_text) converts a text to date
	21.18.2.	=DATEVALUE("22-AUG-2008") converts text to date
	21.18.3.	=DATEVALUE("2008/02/23") converts text to date
	21.18.4.	=DATEVALUE("5-JUL") converts text to date