0205, 2019 The DATEVALUE Function Kornilios Ampatzis/ May 2, 2019/ Functions It converts a text value to the date format that Excel recognizes (serial number).