Afternoon,

I have quite a strange problem that I don't know how to fix! Basically I have a really long list of dates which I want to sort. They're all sorting fine except for a few at the end which no matter what cell format I change them to, do not act like the other dates. I extracted the data from a website so maybe that is something to do with it. dates error example.xlsx

I have attached the workbook as it's quite difficult to explain.

Any advice would be much appreciated!

Thanks,

Alice