Excel - Advanced Filter - AND for single column

[Makhaira]

Currently getting to grips with advanced filters. I know that I can do OR on a single column, or AND across multiple columns, but how can I do AND on a single column?

One of the criteria I want to put in place is to filter a specific Date column such that the Date is less than TODAY()+28 and the value isn't N/A.

Entering AND(<TODAY()+28,<>"N/A") doesn't work... (Tried sticking an equals on the front too, no change.

Any suggestions gratefully received! Thanks.

 

[Makhaira]

No, it was text. I've also tried using the =NA() formula and altering the check to reflect that.

Yea, the only option I came up with that worked was creating a helper column like that, it's just a bit messy. Thanks anyways!