Kornilios Ampatzis/ May 2, 2019/ Functions

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:

Practice

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.

Share this Post