FatalLordes
New Member
- Joined
- Dec 22, 2017
- Messages
- 26
Hi all
I have a huge amount of data (8000+ rows) that includes a start date. What I would love to do is only show data where the start date is between 7 days prior to today's date and 28 days past today's date (so effectively a 5 week period). Obviously the date of today will change depending on when run. Below is sample of my data. How would I go about doing this in VBA please? I have formatted the two date fields to dd/m/yyyy hh:mm, if that makes a difference.
Thanks in advance
I have a huge amount of data (8000+ rows) that includes a start date. What I would love to do is only show data where the start date is between 7 days prior to today's date and 28 days past today's date (so effectively a 5 week period). Obviously the date of today will change depending on when run. Below is sample of my data. How would I go about doing this in VBA please? I have formatted the two date fields to dd/m/yyyy hh:mm, if that makes a difference.
Thanks in advance