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.

custom filter | choose is less than | type today's date and enter

On Dec 1, 11:08*pm, Mike Busch <MikeBu...@discussions.microsoft.com>
wrote:
> 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.

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


"muddan madhu" <(E-Mail Removed)> wrote in message
news:a05a50c5-8f9a-4e9f-a592-(E-Mail Removed)...
custom filter | choose is less than | type today's date and enter

On Dec 1, 11:08 pm, Mike Busch <MikeBu...@discussions.microsoft.com>
wrote:
> 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.

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

"Mike Busch" wrote:

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