How Do I Convert Datevalue to Date?

The DATEVALUE function in Excel converts a date in the text format to a serial number that Excel recognizes as a date. So, the formula to convert a text value to date is as simple as =DATEVALUE(A1) , where A1 is a cell with a date stored as a text string.

How do you convert a number into a date?

Convert serial number to date with formula

Select a blank cell (says cell B2) adjacent to the serial number cell you need to convert to date, then enter formula =TEXT(A2,”m/d/yyyy”) into the Formula Bar, and press the Enter key.

How do I change text to a date?

Convert text dates by using the DATEVALUE function
Enter =DATEVALUE(Click the cell that contains the text-formatted date that you want to convert.Enter )Press ENTER, and the DATEVALUE function returns the serial number of the date that is represented by the text date. What is an Excel serial number?

Below are the steps to do this:
Select the cells that have the number that you want to convert into a date.Click the ‘Home’ tab.In the ‘Number’ group, click on the Number Formatting drop-down.In the drop-down, select ‘Long Date’ or Short Date’ option (based on what format would you want these numbers to be in)