Advanced filter

[Dave]

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.

 

[T. Valko]

Try this...

=">"&TODAY()+7

 

[Dave Peterson]

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

 

[T. Valko]

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

 

[Dave]

Thanks gentlemen!
Dave.

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]

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]

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

Thanks for the feedback!

 

[Dave]

Hi,
The link is:
http://contextures.com/xladvfilter01.html

Then click f) Criteria Examples

Dave.