Make Excel Recognize Dates with the DATEVALUE Function

That Text to Columns function is a MONSTER, y'all!!! Worked PERFECTLY - FIRST time [if ONLY I had known this YEARS ago!!!] - THANKS!!! 🙂

why it don't work on mine __-

I have the longdate - Janury 3, 2021 but when I use the datevalue fuction it doesn't do anything

Beautiful Video, you are a genius

please, What is the reason(s) that makes/make the date in txt format in a cell?

Thanks Doug! This just solved an issue with some system generated reports that has been driving me crazy.

Thanks it worked!

Thank you Big Time!

Thank you so much

This is really helpful, thank you very much

Very helpful! Thank you!

This helped me sooo much thank you!!!

the extra tip looks good.

How can you use DATEVALUE in a range while using a LOOKUP, VLOOKUP, or HLOOKUP, or other search functions?

suppose I am looking something from one column as 12/05/18 to look up something in a row but the searchable column has "Tuesday 12/05/18 6:50pm". can I use DATEVALUE, or anything to that range of fields?

can you convert this one- 18-05-2018. Excel won't convert this!!!! Why?

Many Thanks!

Good post.

I love you

Arlisa