Auto Filter

M

Mike Busch

II used an auto filter with a date column in Excel 2003. I tried to customize
it by having it select only dates before today. How can this be done, in auto
filter. Thank you for your time.
 
D

David Biddulph

.... or if you want it to keep track of the current date, don't type in
today's date but instead type in =TODAY()
 
S

Shane Devenshire

Hi,

In all fairness =TODAY() in the Custom box with less than selected should
work, however, it won't. Also, unfortunately, you can't reference a cell in
the spreadsheet.

So you are stuck with hard coding the current date.

Cheers,
Shane Devenshire
 

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


Top