Extract Date from End of Description with Excel Worksheet Formula - Excel Magic Trick 1583

See how to convert a text data that is part of a description to an actual date with an Excel Worksheet Formula. See three different formulas. The formulas extract the data from a description AND convert it to an actual serial number date that Excel can understand.

[excelisfun]

Bonus Formula #1: 01:05 Bonus Formula #2: 01:26

[aguerojg]

How great video full of tips in only 1 minute. You are so amazing, Mike!

[adhievallianto]

I used to break down the year, month, and days.. But finally, I end up with nothing. Kind a shock actually, the solution you shared could not be any simpler from this. Thanks again 🙏

[wayneedmondson]

Hi Mike.. great tips.. +0, --, DATEVALUE.. super!
Here's another: =VALUE(RIGHT(B4, 9))
..and if you really want to over do it: =VALUE(LEFT(RIGHT(B4, 9), 2) & "-" & MID(RIGHT(B4, 9), 3, 3) & "-" & RIGHT(RIGHT(B4, 9), 4)) - I think this qualifies as a "silly" formula.. haha!!
Thanks for all the great inspiration to test and create. Thumbs up!

[shadow_gaming_sk]

Thanks Mike. I have learned lot of excel stuff from you last 10 years

[danmota]

I didn't know this +0 trick, always used the date value formula! Thanks!

[Officeinstructor]

Thanks Mike... Great Video as always
Congratulations on the July 2019 Record of posting 34 videos :)

[DIGITAL_COOKING]

I think the real record is 3000 Videos you did
As usual very good video 👍👍👍

[katerina]

Thank for another great video Mike, and for the bonus formulas, have a great day Mike

[GeertDelmulle]

What?!... a trivial math op on a piece of text like that will do the trick?
How come I struggled so much on text-dates in the past?
Great set of tricks, right here.

[richardhay]

I always like the bonus formulas. In this case the ....VALUE formulas are too often overlooked and too rarely taught.

[bwgames]

You are the Best. Thanks you so much. I learn English To understand you.👍👍👍

[MalinaC]

There is always fun with Mike-ExcelIsFun :). Thanks for this trick!

[evgeniam]

Thanks a lot Mike! So useful formulas!

[ogwalfrancis]

Always, Amazing Videos from excelisfun, thanks u Mike.

[simfinso]

2 Bonus Formula in 1 Main video.It's Treat for me

[sachinrv]

Hi Mike, at 0:49 SS just press CONTROL+SHIFT+3 combination; which converts the date in the format user has defined viz MMDDYY or DDMMYY as the case may be.. wonderful video :)

[ajayganeshie]

Thanks sir Mike, agian awsome. I was wondering if u can do something like this in power query?

[NestorAdrianzen]

Great tricks, Mike! If the # of characters of the dates differs (eg., 04March2019, 31Jan2019, 29February2024), would you recommend using "LEN" as part of your formula? e.g., = RIGHT(C4, LEN(C4)-4)+0

[sasavienne]

Amazing and so useful as usual. Your tips and tricks help so much. 🌟 🌟 🌟 🌟 🌟 🌟 🌟 🌟 🌟 Thanks..