Normalize date format

[radicaled]

I have format some dates with mm/dd/yyyy on my spreadsheet.
But for some reason after the day 13 the format change and breaks all. Living in Argentina and using the US date format, breaks everything.
I tried to use a couple of formulas to fix it

=IF(ISNUMBER(A2);DATE(YEAR(A2);DAY(A2);MONTH(A2));DATE(RIGHT(A2;4);LEFT(A2;2);MID(A2;4;2)))

=TEXT(A2;"mm/dd/yyyy")

But in both cases something went wrong.

I have attached the excel I'm using to test.
test formats.xlsx

Any help will be appreciate.
Thanks

[Bailey_Thomas]

So the first thing I did was click on the "Open Time" column>clicked format>format cells>custom>typed in mm/dd/yyyy. Like you said the dates still had issues after day 13. so then I clicked the "Open Time" column again>did a Find/Replace (Ctrl+F)> in the "Find What" box I typed in " *" (which is a blank space... and an asterisk)> it tells it to delete everything after the date so it gets rid of all the times after "2014". So leave the "Replace With" box blank and hit "Replace All".
Hopefully that gets you what you need.
Happy Holidays

-Tommy Bailey

[newdoverman]

Sort all the mm/dd/yyyy dates that are giving you trouble so that they are together. Select them and click on the data tab, Text to columns, click Next, Next, Select Date and MDY click finish. The dates should now be in a useable form Then in your column E2 I entered =LEFT(A16,10)*1 and filled down the column. This converted the dates to dates only without the time.

In the file, I have shown in yellow the dates in both formats.