How can I create a custom autofilter that will show me dates within 30 days of today in Excel 2003?
How can I create a custom autofilter that will show me dates within 30 days of today in Excel 2003?
Last edited by tkaye; 12-23-2008 at 12:45 PM.
Last edited by oldchippy; 12-22-2008 at 06:27 PM.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Unfortunately, I don't think advanced filter will work as I am using an excel add-on that changes the information in a query based on the project it is accessing. I need add a macro button that will just go to auto filter and put the formula in equals = due within next 30 days in a the due date column. Date formulas always throw me off.
...figured it out ... I created two cells...one =today() and one =today()+30
then I created a macro that cut and pasted the value from each cell into the custom auto filter drop down (greater than and less than).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks