Simplifying Formula (part 1)
You could use Advanced Filter
which needs only one formula in one cell.
Assume you want to filter today's date out of your list:
ListA
4/22 4/22
4/21 4/22
4/22 4/25
4/25 4/25
4/25 4/23
4/21 4/25
4/21 4/26
4/23 4/25
4/25
4/26
4/21
4/25
Criteria
Test
TRUE
Name ListA (12 cells) and Criteria (2 cells)
Where it says TRUE enter this formula:
=NOT(ListA=TODAY())
|