Excel Challenge 25: Convert Dates Stored as Text

Excel dates can be tricky to work with, and we're taking on that challenge this month.

To get started,

1. Watch the challenge video. 
2. Download the Excel worksheet. 
3. Complete the challenge tasks.
4. Share your solution, discuss it, or ask for help in our Slack channel.

The challenge 🧠

The task 🏋️

We'll need you to use your knowledge of Excel dates to extract the tasks that started in the year 2022. But look out! All is not as it seems!

At a glance, this may appear to be quite simple, but taking on this challenge may involve several steps since some of these dates are not correctly formatted in Excel.

The clues 🕵️

We have some resources on some of our favorite date functions in Excel, and another on how to filter values that satisfy certain criteria.

		Read - Working With Dates in Excel
		Read - How to Filter in Excel

Tell us how you would solve it, then check out our solution below!

The solution 💡

We hope you enjoyed taking part in this challenge!

Hungry for more? 🍔

Can't get enough Excel? 😃 We recommend:

1. Trying our previous challenges to sharpen your other Excel skills. 🤹
2. Subscribing to our YouTube Channel 💻 so you never miss another tutorial or future challenge.
3. Joining the GoSkills Slack community 👪 to connect and chat with other Excel nerds.

And check out our expert-led Basic to Advanced Excel course, where you can get certified in Excel at your own pace!