DATEVALUE Function Explained
The DATEVALUE Function in Microsoft Excel converts a date that is stored as text into a serial number that Excel recognizes as a date. This allows the user to use the date in calculations and other operations. The function takes a single argument, which is the text string that contains the date.
DATEVALUE Function Syntax
DATEVALUE(date_text)
- date_text: A text string that represents a date in a date format recognized by Microsoft Excel.