I have some very mysterious date fields in a huge (600 000 records) CSV file which absolutely refuses to behave.
They come up aligned left, and conditional formatting shows that they cannot be seen as dates for some reason, even though they are formatted the same as all the other dates — d/m/Y.
What's more, these same dates are the ones giving me trouble when importing users into WordPress using wp-import. In their user profiles, they show today's date. About half the dates are doing this.
Any light that could be shed on this would be much appreciated.
UPDATE: Here is a link to a sheet with a sample of date fields.