Hi all, wondering if anyone could help with this.
I have a sheet, Column E is full of dates. Some are in the past, some are in the future. I was to apply a filter which shows me all of the dates up until 2 days in the future from today.
So all the dates in the past, and todays, and two days in the future. Any dates ahead of two days from today need to be filtered away.
I have the following formula which shows me all the future dates from today:
But I cant figure out how to change it to do what I want it to.
Any ideas?
I have a sheet, Column E is full of dates. Some are in the past, some are in the future. I was to apply a filter which shows me all of the dates up until 2 days in the future from today.
So all the dates in the past, and todays, and two days in the future. Any dates ahead of two days from today need to be filtered away.
I have the following formula which shows me all the future dates from today:
Code:
Selection.AutoFilter Field:=9, Criteria1:=">=" & Date, Operator:=xlAndAny ideas?