VBA If date = today or past 5 days

  • I have the following code which works perfectly until I want not just today's date, but the past 5 days as well

    I've tried

    If wsheet.Range("A" & x) = Date or Date - 1 or Date - 2 or Date - 3 or Date - 4 or Day - 5 Then

    however, this copies every date, even if they are way older than the previous 5 days days. How do I modify so that it will copy and paste all dates that are within the past 5 days from today?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!