The DATEVALUE function converts a date in the form of text to a date code. For example, the formula:
DATEVALUE("8-Aug-1997")
returns the date code 35649, as does
DATEVALUE("8/8/97")
If the year is left out, the date code will refer to the current year.
See also: