Can't beat that with a stick <g

--
Regards,
Tom Ogilvy

"Duncan_J" wrote in message
...
Hi Tom how are you doing?
Thanks for all the help in the past..
I'm just using =today() in the far right coulmn and beside that a coulmn
with =P2-F2 format the coulmn for numbers and filter less than or equal to
7... Works good enough...
Have a good weekend...
DJ
"Tom Ogilvy" wrote:

Turn on the macro recorder and perform the action manually. Use a
custom
criteria and pick two dates (doesn't really make any difference which
two).


Turn off the macro recorder

Now adjust the recorded code to apply the criteria you want.

--
Regards,
Tom Ogilvy

"Duncan_J" wrote in message
...
Hi Folks,
I use to have this code but forgot it... I need to filter coulmn F
less
than
or equal to todays date, and greater than or equal to todays date
minus 7
days. I had the code that would do that but alas it's gone...
Thanks for any help..