It converts a text value to the date format that Excel recognizes (serial number).
The syntax of the function is the following:
DATEVALUE(date_text)
date_text: The text that we want to convert to date
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the DATEVALUE function:
Display, in the cell I2, the date of cell A2, as number, with the use of the proper formula.