Forum Discussion
Advanced filter by DATE
Does Advanced filter allow for DATES by Month only. I'd like to enter a month in a cell and auto filter the table for all data points with the month regardless of year. This is the table: ...
Let's say the dates are in C2:C100.
If necessary, insert an empty column in column D.
Enter the word Month in D1.
In D2, enter the formula =MONTH(C2) and fill down to D100.
You can now easily use AutoFilter or Advanced Filter to filter the data by month.
Hans THX.
Helps however I want a user to enter data under Enter MONTH (can be a 7 for July or a list of months) then for filter to screen for only those months.
Age Date of Birth By month Month Enter MONTH
94 1927.07.01 7/1/1927 7
90 1931.05.01 5/1/1931 5
57 1964.07.01 7/1/1964 7
Helps however I want a user to enter data under Enter MONTH (can be a 7 for July or a list of months) then for filter to screen for only those months.
Age Date of Birth By month Month Enter MONTH
94 1927.07.01 7/1/1927 7
90 1931.05.01 5/1/1931 5
57 1964.07.01 7/1/1964 7