DATEVALUE function

Converts a date in the form of text to a serial number