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