nniedzielski
Well-known Member
- Joined
- Jan 8, 2016
- Messages
- 590
- Office Version
- 2019
- Platform
- Windows
I am trying to build a macro that will filter all dates in column G that are more than 2 business days out, so weekends removed. I tried recording one, but just got this:
which is great for today, but will obviously not work tomorrow. How can I set the logic to always grab any dates further out than 2 working days?
2nd Note, I also need any dates in the past as well, they are super rare, but need to grab those too.
thanks,
VBA Code:
Selection.Range("$A$1:$AT$937").AutoFilter Field:=7, Criteria1:= _
">6/11/2021", Operator:=xlAnd
2nd Note, I also need any dates in the past as well, they are super rare, but need to grab those too.
thanks,