Advanced Filter Using Calculaions
 

I KNEW it had to be something simple... LOL those are always the worst to
find... :) Thank you both so much... it's working like a charm now... I
was even able to do it on two seperate columns as an OR... which is a
bonus...

Cheers
Tara

"Ron Coderre" wrote:

Just a minor point, Peo...

With a formula criteria, the first cell can be anything except a column
title from the Data List.

Using your example, E1 could be "BeforeYesterday", which is more descriptive
than just a blank, while making it more obvious that E1 is part of the
criteria.

***********
Regards,
Ron

XL2002, WinXP


"Peo Sjoblom" wrote:

In your criteria range, remove the header you would normally use and leave
that blank, then in the cell below put

=A4<TODAY()-1

where A4 is the first cell in the date range (first data cell, not header)

then use the same criteria range including the blank header so if the
criteria range that didn't work had a header called Dates in lets say E1 and
a condition in E2 you still would use $E$1:$E$2 as criteria range albeit
with E1 empty of contents



always when you use a formula as criteria you need to leave the criteria
header blank and refer to the first data cell in the range you want to
filter
--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"T_Amee" wrote in message
...
Good Morning,

I have a file that has a column of dates. I would like to use advanced
filter to filter anything with a date that is <today()-1 but I can't seem
to
make the fomula work. I can make it filter on =today()-1 but when I use
the
< it doesn't calculate today's date and gives me nothing.

I'm sure it's simple but I'm missing something.
Thanks!
Tara