MICROSOFT EXCEL SORTING

I am very confused as to why sometimes I sort a large amount of data by the date column it works and other times it does not.  Here is a sample of one that would not sort by date correctly.