Convert Text to Date Values in Excel - Multiple Examples

In this video, we will demonstrate a variety of techniques to convert text to date values in Excel. These will include formulas and also good old classic Excel tips.

Analysing data using dates is very commonplace. But if Excel does not recognise the values as dates, then its all useless.

This video walks through different scenarios and their solutions to convert the text to date.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[penguin]

You have made some of the best Excel videos I've ever seen. Please keep them coming, although, I am only about 3 or 4 videos into your library of tutorials. Helping me no end with my day job :) All the best Sir.

[sasavienne]

That is stunning. Thank you so much Alan. I appreciate your efforts to make such great videos.

[wayneedmondson]

Hi Alan.. another great lesson. Thanks for the conversion tips and tricks. Gaga is always full of useful and informative information. Thumbs up!

[melguzman]

Amazing. The internet is sweet but your presentation is sweeter. I am giving you lots of hugs of appreciation for making complicated life very simple. You are the best Alan. Thank you.

[Luciano_mp]

Very cool, good tips, it will help a lot. Thank you

[sakawathossainshohag]

Thank you! it's very helpful to me, too much useful.

[rkpatil]

Thank you! it's very helpful to me.

[MariaB-sror]

Thank you! This was the exact answer I was looking for :)

[shallymarcoe]

Very clear and just what I needed. Thank you

[abrahamchiluba]

Find and replace proved helpful. Thanks.

[alexandrkrav]

Alan, thank you so much you save my nerves and time to replace COMA in LONG list of Date data. Regards Alexander.

[neetubahl]

Thankyou so much for the technique. You really helped me today :)

[divyanivalkar]

Thank you so much. It very useful for me while working on text date big data.

[fionawang]

really so useful thanks for sharing ^^

[luafahy]

Thank you! You saved me a lot of frustration!

[cashwebster]

Thank you. You saved me a lot of time.

[sdin]

You just solved a headache for me... thank you!! you deserve a like and subscribe for this for sure!!...

[RA-rhlb]

this is what I needed today. thank you so much.. yes its useful.

[mohammedalmashibi]

Excellent, solved all doubts. Thank you

[khawarmehmood]

thankx alot dear your video helped me alot