| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use a formula in custom autofilter
I want to autofilter a column of dates to show only those that are less than
7 days from today. In the Autofilter Custom feature I've tried "=TODAY()+7" (with and without quotes) but that does not seem to work. I know I could just put in the exact date but I was trying to write a simple macro, so I wanted the date to be a variable. Does Autofilter not take a formula? Then I tried putting "=TODAY()+7" in a cell and referring the custom autofilter to it, put that didn't work either. Any ideas? TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Autofilter | Excel Discussion (Misc queries) | |||
| Custom AutoFilter | Excel Worksheet Functions | |||
| Can I use more than two conditions in custom autofilter? | Excel Worksheet Functions | |||
| custom autofilter dropdown | Setting up and Configuration of Excel | |||
| Custom Autofilter List | Excel Discussion (Misc queries) | |||
Threaded Mode
