MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro that enter todays date into custom autofilter


Posted by Bo on November 13, 2001 11:57 AM

I need a macro that gives me the possibility to have a list of dates and then via the autofilter choose todays date and coming dates. I did try to make a macro but it didn't record the input of the function "TODAY()" in the custom autofilter field. Do You know a smart solution?


Posted by bob Umlas on November 13, 2001 12:33 PM

Not sure I follow. Enter =TODAY() in a cell, say B2, and in the cell below enter =(cellabove)+1, like =B2+1, then fill this down. When you filter on this list, you can pick whatever you want. Am I missing something?