10 to 15 min.

So my other question is there a way i could filter column B with the date as it is yyyymmdd vs. changing the column then using:
Rows(1).AutoFilter Field:=2, Criteria1:="<=" & Date - 180