View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nav Nav is offline
external usenet poster
 
Posts: 43
Default 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?