One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?