Using formulas in autofilter

[danmac]

Hi there, is it possible to use formula with autofilter? I have a sheet with a table for which I need to create 4 temporary view presets. One of filter parameters is whether the date in a given cell is larger or smaller than today and 30 days from today. One way to do this would be to implement another column in the table with a formula giving True/False results but I'd like to avoid this if possible. Any ideas?

 

[Accelerate Excel]

You could pull the data into a Pivot Table and use slicers for dynamic views.

 

[danmac]

You could pull the data into a Pivot Table and use slicers for dynamic views.

This could work. However, other people using the spreadsheet has extremely limited knowledge of Excel zero willingness to learn. Clicking through different tabs and refreshing a pivot table is way too much. The table will be updated on each use so the idea is to use different presets for autofilter.

 

[RoryA]

You can only use certain built-in date filters with autofilter without a helper column. You could always use code with a button for each view, or a dropdown to select which view you want.