Thanks gentlemen!
Dave.

"Dave Peterson" wrote:

Try:

=""&TODAY()

It'll look funny. You'll see a 5 digit number, but should work ok.

ps. I'd look at Debra Dalgleish's site for tips with advanced filter.
http://contextures.com/xladvfilter01.html
and
http://contextures.com/tiptech.html

Dave wrote:

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.

--

Dave Peterson
.