DATEVALUE(date_str)
DATEVALUE returns the serial number of the date. @date_str is the string that contains the date. For example, DATEVALUE("1/1/1999") equals to 36160.
DATE