Excel date conversion

This shows 2 ways of converting an incorrect date format into a format Excel can recognize and use in formulas.

[@warrenfield7530]

Thanks - clear, to the point advice that works

[@sureshbabugannamani7985]

THANKS FOR SHARING ...I WASTED SO MUCH TIME TO LEARN THIS....BUT YOU DID IT WITHIN NO TIME.....THANK YOU

[@jaipalrana.]

This is superb example for anyone who is looking to convert date at its own choice!!!!!

[@ranib.el-ayoubi6323]

thank you! very much for the quickest help
🤩

[@lestercantem7740]

Thank you very much for helping me out for my tax returns!

[@varundagar8634]

thanks really informative !!

[@welsadventures1717]

How do you convert series of numbers into date?
For example I have 1231206 and want to convert it to 12/06/23?
So there is the 1 extra in front of yymmdd...is there a simple formula to convert that into a date? Thanks

[@soumiamoujane3695]

What is the format for day, date, Month, year?. Without my cell box,

[@fishregulator]

just saved my job 😂