Advanced Filter with dates in the criteria

[Wild Bill]

I'm having a little trouble with Advanced Filter. I want to filter on a date field and capture the rows where the field is blank or where the date is >01/31/09. The result is giving me rows that include dates that are <01/31/09.

My criteria range looks like this:

DIL Actual Deliv Date Due Date
J-27 <=01/31/09
J-27 >01/31/09 <=01/31/09

I should get 9 rows from my dataset, but I'm getting 14 because 5 rows are appearing that have an Actual Deliv Date <01/31/09.

Is there something special about dates in criteria ranges that I'm missing?

 

[Wild Bill]

My criteria range came through a little messed up. The first row under Actual Deliv Date is blank. I want to capture rows with no Actual Deliv Date shown or with an Actual Deliv Date > 01/31/09. The Due Date is <=01/31/09 on both rows.

 

[Wild Bill]

I think I've got it.

I added a column to the criteria range with no header. The criterion in the first row of that column is =ISBLANK('All Items'!Y3), where Y3 is the first data row under the Actual Deliv Date column.

The Actual Deliv Date column is blank on the first row of the criteria range and shows my date criterion on the second row.

So it wasn't the dates that were a problem but the blank.