variable date not working with date add?

[Grimbarian]

Hi everyone,

I have an array of dates and I'm trying to search for dates that are more than 2 years old but I can get the dateadd to work with the search loop. can anybody tell me why the code isn't working please.

Please Login or Register  to view this content.

Thanks

[Grimbarian]

Fixed it myself with
If due.Cells(i, j).Value < (Date - 730) Then

cheers