DATEVALUE(date_text)

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:

Other date functions