Filter does not recognize "Date is blank"

Anne Abrams

I have created a whole bunch of saved filters that work like a charm.

I need one more, super easy, but can't get it right.

First colum is "Lot #" and the criteria is "contains Spec" - checked.

Second criteria on colum "Date Closed" "Is blank". Simple, isn't it?

Well, when I apply the filter - all the rows where there is a date in the "Date Closed" column are displayed.

If I do the reverse: Date is not blank, then it works perfectly.

What am I doing wrong? (I verified that the "Date Closed" column is formated for dates).

Thank you in advance for your help.

ricki

Thats so weird. I set up a similar filter on a date field that i have and is blank returned all blanks and is not blank returned all not blanks

 

Could you possibly have two Date Closed fields in your sheet?

J. Craig Williams

Have you set the filter to 

 

Show rows that match at least one condition

or

Show rows that match all

 

When there are dates shown, what is the Lot # field?

 

Craig