Filtering data

[David Tunstall]

Please help.

I am filtering data in a worksheet. I have my list range
and where the data is going to copy to but I am struggling
with the criteria range. I need to filter by any date less
than 01/08/2001.

I have tried Sheet1!$I:$I<01/08/2001 but it just says
reference is not valid.

Thanks in advance
David

 

[Peo Sjoblom]

One way

Use $I$1:$I$2 as criteria range
leave I1 blank and in I2 put

=A2<DATE(2001,1,8)

where A2 is the first cell with the dates

if you are copying to another sheet you need to start from the sheet where
the
filtered list is supposed to be in