Use the DATEVALUE function to recalculate dates formatted as text - Date and Time Functions - Microsoft Excel Tutorials

Use the DATEVALUE function to recalculate dates formatted as text using Microsoft Excel

Figure shows start and end dates in columns A and B. Excel cannot interpret the columns as dates because they are formatted as text. To convert and calculate these types of dates, use the DATEVALUE function. This function returns the serial number of the date represented by the “text date.”

Let’s determine the difference between start and end dates.

To calculate the difference between text dates:

1. Select cells C2:C10.
2. Type the following formula:
=DATEVALUE(B2)-DATEVALUE(A2).
3. Press <-Ctrl+Enter->.

Use the DATEVALUE function to recalculate dates formatted as text

Watch the Video Tutorial - https://www.youtube.com/watch?v=TGl_Ea0C5Wc