Copy rows of data that meet date range criteria to new sheet

Hi there,
I have a macro that identifies all rows of data containing an expiry date effective today to 60 days from now, and copies those rows to a new worksheet. I want to filter all rows that contain an expiry date within an approximate two month range starting today. Unfortunately my code returns everything starting today and ignores part of the condition. I don't know if there is a problem with the date formatting though I've checked it. If there is a better way of coding this I would really love to know and all help is appreciated.

Please Login or Register  to view this content.