filter with formula
 

I'd like to set an auto filter that will filter out any data with a date
greater than today.

What I'm looking for is a way to set the auto-filter to:
"Column data" is greater than =today()

But I can't seem to get it to work....
Anyway to filter dates with an =today() formula?

filter with formula
 

Using the auto-filter, select the Date field, then goto custom. A dialog box
will open and enter greater than and the date you require for the criteria.
This should filter any data correctly as you require from the description
below.

"Brian" wrote:

I'd like to set an auto filter that will filter out any data with a date
greater than today.

What I'm looking for is a way to set the auto-filter to:
"Column data" is greater than =today()

But I can't seem to get it to work....
Anyway to filter dates with an =today() formula?