Fix dates stored as text
Spot dates stored as text, turn them into real dates with DATEVALUE, and rebuild any other layout with DATE, LEFT, MID and RIGHT.
In this lesson
- Signs of dates stored as text.
=DATEVALUE(A2)turns text in your spreadsheet's date layout (such as 9/28/2026) into a real date.- Any other layout: rebuild it with
=DATE(year, month, day)and LEFT, MID and RIGHT.
Try a free lesson first
Delete repeated rows from a merged list, and choose which columns decide what counts as a duplicate.
Confident · 9 min · Free, with no sign-up
Do the free lesson on your computer.
Send yourself the link and open it on a laptop or desktop.
On your computer, go tolearnford.com/go/BV7C
This lesson is in the full Google Sheets course
US$149 once
Tax included. New lessons are added as they're written.
Get the full course, US$14930-day money-back guarantee if you've opened fewer than 10 paid lessons.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- Skill
- Data cleaning
- Stage
- Confident
Where it sits in Data cleaning
The steps
13 steps: 4 explanations, 7 Do this, 2 questions, then Your turn.
Try a free lesson first
Delete repeated rows from a merged list, and choose which columns decide what counts as a duplicate.
Confident · 9 min · Free, with no sign-up
Do the free lesson on your computer.
Send yourself the link and open it on a laptop or desktop.
On your computer, go tolearnford.com/go/BV7C