DATEVALUE

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