Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Calc-sheet where the first column is a date and the second column a description of a task. I would like to filter the table so only the task with a date equal to today and the future will be shown.

For example if the dates where 01-01-2010 and 01-01-2013, then 01-01-2013 should be visible, but the 2010 should be hidden.

share|improve this question
up vote 2 down vote accepted

Here's a solution using an advanced filter. First, you need to define the filter criteria. After this, you can apply the filter to your data.

The filter criteria definition for an advanced filter is a simple table using the same structure of your data. You can put that data table on the same Calc sheet as your data.

Since you want to filter your data dynamically, you'll have to define the filter dynamically, too (if you don't want to update the filter criteria manually). To do so, enter a calculation to get the current date.

In the following screenshot, cell B10 has the content =NOW(), resulting in the current date. The search criteria is defined in A7:B8 (yellow background). A8 is defined as the result of this formula: =CONCATENATE(">=";B10). The date part of the resulting string is displayed not as date but as Calc's internal numeric representation of the current date. You may add a name to filter area range to make it easier to reference it.

data with filter criteria

Now, with the filter criteria created, you can apply the filter using Menu Data -> Filter... -> Advanced filter:

Advanced filter

Enter the cell range of the filter criteria and hit OK.

That's it - as result, only tasks with date >= now will be shown:

result

To remove the filter, Select Remove Filter from Menu Data -> Filter.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .