S
Scott
OK guys. I have a column with 20,000 dates in. They should all be in
the format that is DD/MM/YYYY, but some times people have only put days
and months and occasionally random characters are in there too.
Is there a formula to search for cells in column A that are not
DD/MM/YYYY? I have tried using autofilter and stuff but that is not
very quick.
Many thanks gang!
the format that is DD/MM/YYYY, but some times people have only put days
and months and occasionally random characters are in there too.
Is there a formula to search for cells in column A that are not
DD/MM/YYYY? I have tried using autofilter and stuff but that is not
very quick.
Many thanks gang!