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(A1TODAY(),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

=A1NOW()

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" wrote in message
...
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?