Hello!
I have a sheet that contains details of club members with their join dates (col E) and date of their last visit (col B).
I need some code that will filter out members that haven't visited in at least 2 months (or 61 days) from today's date - but also joined before then (to avoid including new joiners who don't haven't even visited for the first time yet).
The data range is indefinite (as member numbers change all the time) so the code will need to find the last row.
I have some existing code for another project that kind of filters by date so this could be used as a model but it's not specific to this purpose...
Please can someone help me out?Please Login or Register to view this content.
Thank you!
Bookmarks