Sorting an excel lists

I have a list I exported into Excel from Sierra. I want to sort the list according to the last check out date, descending. The cell for the date includes the date and time. Some of the cells have two dashes instead of a date. I can’t seem to get it to sort by clicking on the column and sort. What am I missing?