I have a column of dates in my table, but Excel is not recognising a handful of them in the same format as the rest. This is causing big issues if I have to search for relative dates or sort the dates accending/descending- as it leaves them out.
I have attempted to select all the dates and format them together, but it didn't work. Selecting the format and retyping each date worked for a while, but that has stopped working.
In the attached image, all unselected dates are not recognised in the same format as the rest.
Help PLEASE...
