How do I filter a list using a greater than todays date function?

I'd like users to be able to view data in a worksheet by anything greater
than todays date. How do I do this without sorting the sheet myself? I'd like
to customize an autofilter but it seems that I have to go in and define the
custom filter everytime I want to re-filter the data. And I can't seem to
figure out how to do it using the advanced filter.

Any suggestions?

=IF(A1>TODAY(),A1,"")
This will automatically "hide" the dates earlier than "Today". You may want
to hide the date column-or you may want to use the spreadsheet and have the
results with this filtering formula on a 2nd display tab!
Pat

"LV" wrote:

> I'd like users to be able to view data in a worksheet by anything greater
> than todays date. How do I do this without sorting the sheet myself? I'd like
> to customize an autofilter but it seems that I have to go in and define the
> custom filter everytime I want to re-filter the data. And I can't seem to
> figure out how to do it using the advanced filter.
>
> Any suggestions?

LV,

Simplest to do would be add a 'helper" column, with a formula like

=A1>NOW()

where A1 has a date (then copy the formula down to match your data). Then
you can filter your list based on that column, for TRUE values. You will
need to re-filter to get it to update properly, but that should be easy.

HTH,
Bernie
MS Excel MVP


"LV" <[email protected]> wrote in message
news:[email protected]...
> I'd like users to be able to view data in a worksheet by anything greater
> than todays date. How do I do this without sorting the sheet myself? I'd
like
> to customize an autofilter but it seems that I have to go in and define
the
> custom filter everytime I want to re-filter the data. And I can't seem to
> figure out how to do it using the advanced filter.
>
> Any suggestions?