Thread: Advanced filter
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Advanced filter

Good deal. Lot's of good stuff on Deborah's site. I refer people to it
often.

Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"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.




.