So part of the process I wish to incorporate into my macro includes a step where I would filter column D (which are a series of dates) by two requirement:
1) Show all dates before last month
and
2) Show all dates listed as 00/00/00
I was able to filter for the dates before last month using...