I have a spreadsheet with a drop down box that has dates in it in C1.
Below that I have data that I need to filter based on the date in the drop down box occurring between 2 dates listed in the data below it.
I have already taken care of the date ocurring between the 2 dates by writing a formula that returns a simple "YES/NO" as a result. "YES/NO" is located in column N starting with header in row 4 and data in row 5.
My issue is getting the list to refilter using autofilter to "YES" whenever the Date in C1 is changed.
TIA for any help.
Below that I have data that I need to filter based on the date in the drop down box occurring between 2 dates listed in the data below it.
I have already taken care of the date ocurring between the 2 dates by writing a formula that returns a simple "YES/NO" as a result. "YES/NO" is located in column N starting with header in row 4 and data in row 5.
My issue is getting the list to refilter using autofilter to "YES" whenever the Date in C1 is changed.
TIA for any help.