Extracting excel readable date from manually entered date format

I can't seem to find a formula that transforms these type of date formats into something that Excel can read and sort. It was manually entered so Excel can't read them as a format.

I've tried LEN, FIND, LEFT, RIGHT. Any help please?

20170215193647.png

Try this ...

=--SUBSTITUTE(A1,".","/")

Format ->Date

Awesome!!! Thanks

Just curious, why use 2 minus signs? I know it has to do with TRUE/FALSE and 1/0, but not sure how it transforms the dates?

--"2013/12/13" = 2013/12/13

"2013/12/13"+0 = 2013/12/13

-- -> convert text to number.