View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zebrageek Zebrageek is offline
external usenet poster
 
Posts: 2
Default Show only future Dates

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! :)