filter with formula

B

Brian

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?
 
N

Nav

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.
 
Top