Make Excel Recognize Dates with the DATEVALUE Function

Sometimes you get a file that has dates that don't seem to work like real dates (i.e., you can't perform calculations on it). Maybe those cells have dates that are really 'text' dates, not values. You want to represent these text dates into a proper Excel date (which is a serial number). It'll take the text string date and transform it without any VBA. This video show you how to changes those text dates to 'real' dates so you can perform calculations. 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough #excel #msexcel #doughexcel -~-~~-~~~-~~-~- Please watch: "Convert Table in a PDF File to Excel" https://www.youtube.com/watch?v=COUOvhbQ4CQ -~-~~-~~~-~~-~-