Think JE's solution works fine ..

Just ensure that your sample data is split*
so that only *dates* are in col A

As outlined in your other post, to split:
use Data > Text to columns on the col with "Date - Time"

In the wizard:
Step1: Select "Delimited" > Next
Step2: Check "space" > Next

Step3:
In the data preview pane:  click to select the dates col
Under "Col data format": Select "MDY" from the drop menu

Click Finish