Of course I meant eleven, not fifteen. Too early in the morning. :-(
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I would expect 1/11/01 to look for a value greater than (one divided by
fifteen then divided by one). Are you sure that you saw that on Deborah's
site? Could you give us the URL of the relevant page, please?
--
David Biddulph

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




.