Date Functions
Intermediate
DATEVALUE Function
Convert text to date values using DATEVALUE.
Task:
Convert text dates in column A to actual date values in column B using DATEVALUE.
Learning Objectives:
- Learn DATEVALUE function
- Understand text-to-date conversion
- Practice data type conversion
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Text Date | Date Value |
| 2 | A | January 15, 2023 | |
| 3 | B | May 20, 2023 | |
| 4 | C | December 31, 2023 |
What this exercise teaches (contains the answer)
DATEVALUE converts a text string that represents a date into a date serial number that Excel can use for calculations.