I can export data from my mrp system, however the date an issue occured has a
timestamp which is

DD/M/YYYY HH:MM:SS

What i want to do is be able to reformat this is that it is just DD/MM/YYYY
but whatever i do i cant remove the time even thou the format has change on
the display. I want to be able to count how issues happen in a day so use

=COUNTIF(A1:A1000,B1)

with A1 :A1000 being the range and B1 being the date i reqiure looking up in
format DD/MM/YYYYY

However it always returns 0 because of the additional time characters.

Any ideas?????????????????

Cheers