On / Before 12th the format is MM-DD-YYYY and 
 On / After 13th the format changes to M/DD/YYYY.
And why is that?
What is the use for that?

Why not change the problem at the bottom => in your Original data.

Then you are able to use my formula.