|It may LOOK like a date, but it is probably TEXT.|
Try this with one of the offending Dates:
Format the cell as Number, if the cell displays as a Date,
then the date is really TEXT,
if it displays a five digit number like: 41830
then it is a Date that Excel understands.