I need to filter multiple columns with dates. For example, I have 7 rows of names and the columns contain the dates they had office visits. So I want to be able to see the visits that occurred in a specific month. For example, I want all the visits to show that occurred in June which are listed in multiple columns.
Column A would have the name, Column B-E have other data about this person, Column F-I each have dates. If any cell in Column F-I contains a date falling in the specified month, I want the filter to show only those rows.
Can I do this with an advanced Excel Filter? If not, how can I do this?