Hi Biff,
Yeah, thanks for that. I picked that up off Deborah Dalgeish's site - the
AND being criteria on the same row, and the OR being on different rows. But
she was using actual dates in her example, so she used 1/11/01 and <1/25/01,
without any quote marks, which didn't work when I used the TODAY() function;
hence my original post.
Regards - Dave.

"T. Valko" wrote:

I want to filter on the basis of any date being
between Today and 7 days later.

Ooops!

I missed the double criteria.

Try this...

Assume the column header is named Date.

As the criteria enter this in the criteria range:

.............Date...........................Date
="="&TODAY()........="<="&TODAY()+7

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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.




.