filter with formula

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced filter 7
Pivot table macro filter data between yesterday and today (date+time) 0
MS Query - Filtering all dates greater than the current date 1
alternate row shading on filtered data 2
Auto Filter 3
what formula do I use to pull rows containing a number? 1
Auto filter for multiple columns 2
Custom Filter w/ formula 1

Top