Sorry... saw the typo as I clicked post...
My data range is $a$8:$s:5000.

"Ron Coderre" wrote:

Try this:

With a list of dates in A4:A100
A4: MyDates

A1: MyCriteria (or blank or any other text that is not a column title)
A2: =A5<(TODAY()-1)


From the Excel main menu:
<data<filter<advanced filter
List Range: $A$4:$A$100
Criteria: $A$1:$A$2
Click the [OK] button

Using that technique the Advanced Filter will sequentially apply the formula
in A2 to each data cell in the list range, beginning with A5.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"T_Amee" wrote:

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