Excel DATEVALUE Function
What is the Excel DATEVALUE Function? The DATEVALUE function converts a text representation of a date into a proper excel date (a serial number recognized as a date by Excel). Proper excel DATE is more useful than a date represented as text when you want to …