I’m having a challenge in actually finding a working formula to convert the below inputs into a date format. I’m on excel for Mac. Inputs are in these forms:
1/1/20241/16/202412/12/202312/1/2023
I’ve tried multiple formulas but couldn’t quite make it work. To get the year is easy, but to extract the month and day based on their dynamic position was something I could not accomplish.
Maybe someone is an excel wizard and can help.
Thanks
2