VBA Code to automatically change date and time format when pasting new data in a table

Is there code I can use to automatically reformat data when pasting values from a large data-set into a table?

Basically I have a dashboard that gets updated every week with thousands of records and for each event date, I need to use the "Replace All" function to remove the time from the end of the date in the event date column.

The reason for this is because mu COUNTIFS formulas do not work with the standard export format however, it works perfectly with the format in the example below.

Desensitised example attached including how the data is exported and the outcome I am looking for automatically in the table.

Thanks

Try using code like

Please Login or Register  to view this content.

Are you using a data connection? Or are you copying and pasting? If so, are you pasting values only, or formats as well? Can you share a workbook?

This seemed to work on your example worksheet:

Please Login or Register  to view this content.