DATEVALUE(date_str)
DATEVALUE returns the serial number of the date. @date_str is the string that contains the date.
This function is Excel compatible.
DATEVALUE("1/1/1999") equals 36161.
DATE.