I have a spreadsheet with a date column.
In that column, are dates which are both in dd/mm/yyyy and mm/dd/yyyy. Excel believes them all to be dd/mm/yyyy so I can't simply convert them all.
I wonder, besides manually looking for and changing the US dates into UK dates, is there anything I can do?
I have attached sample data - i've highlighted the incorrect dates in red for the first few. The only way I know they're wrong, is because they should generally be in chronological order, and also many of them are showing as future dates.
![]()
Bookmarks