Below is a possible solution to the Challenge 63 - Convert to Date Format
Put following formula and drag down
SUBSTITUTE(A1,",","")," ","*",2),"*",", "))
This time, you have been given a file containing Text dates into various formats. The challenge before you is to write a single formula to convert them into an appropriate date format.
The challenge file can be downloaded from Challenge 63 - Convert to Date Format
The solution to the above challenge will be published after a month i.e. on 10-Jul-17.