Try this...

=""&TODAY()+7

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Hi,
XL 2003
I am having trouble using Advanced Filter.
Column A has Dates (formatted as date), and Column B has Names.
I want to filter on the basis of any date being between Today and 7 days
later.
Not having success with this, I tried just filtering on anything greater
than Today.
In the criteria range, I have: ="TODAY()"
But when I applied the filter, no filtering takes place. All dates are
shown.
I haven't used advanced filter before. What am I doing wrong?
Regards - Dave.