Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation of future dates | Excel Discussion (Misc queries) | |||
future dates | Excel Worksheet Functions | |||
future dates | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions | |||
Formatting dates in the future | Excel Worksheet Functions |