The Auto Filter has a "custom" option for each column that allows you
to specify "is greater than". Just click the filter arrow in the End Date
column and select custom.
--
Jim Cone
Portland, Oregon USA



"Zebrageek"
wrote in message
I am trying to filter a list that has a column of start dates, and a column
of end dates. I want to ONLY show the end dates which are still in the
future. Essentially - like a subscription list - who still has a valid
subscription based on the end date of when their subscription ended. I can
do an If/Then finction in another sheet, but I can only get that to go line
by line to compare, and leave a blank if not true. How can I do this, either
with Filter or if/then to only see current subscriptions in a different sheet
than the main database? Any Help wouldbe great! :)