I am based in the US but am using a file that originates in the UK (I believe). As you will see from the table below they all appear to be dates but when a formula is used the data doesn't act like a date.
I have tried to used format cell function and change to a US format date, with no luck...