Autofilter with International Dates

Hi all,

I've created a macro that autofilters everything within the next 7 days of the current date along with several other criteria. It works perfectly on my computer in the US, but my UK counterpart seems to come up with incorrect rows. My guess is that it is a date formatting issue, but I'm not sure how to get around the problem. I have posted the macro below.

Please Login or Register  to view this content.