Can you filter a date range in Numbers 3.1?

Question

Level 2

263 points

Can you filter a date range in Numbers 3.1?

It seems crazy... but I can't figure out how to filter a date range in the new Numbers (3.1). In other words, I have a column with individual dates e.g. 31-Dec-2012, 29-Feb-2013, 19-April-2004, etc.

I want to filter it so that ONLY the dates from 2012 show up.

The thing is that the new filters ONLY seem to let you filter from today's date e.g. between 494 and 692 days from today. Obviously, that isn't what I want, and it seems very wierd that something so basic would be left out.

What am I missing?

iMac, OS X Mavericks (10.9.1)

Posted on Mar 29, 2014 9:40 AM

Reply

Answer 1

Badunit

Level 7

30,924 points

Mar 29, 2014 12:10 PM in response to Tor Lundgren

Like this? If I click the checkbox to turn the filter on, it will show only the two dates in 2012. The filter "date in the range" is at the bottom of the list of date filters and you have to scroll down to see it.

Reply

Answer 2

Mar 29, 2014 10:44 AM in response to Tor Lundgren

In the example below Column A has date values and Column B has a simple filter that displays dates if in year 2012. Pretty simple, likely too simple. Not sure what/how you want to display but thought I'd get something started. The formula in Column B is: IF(YEAR(A2)=2012,A2,""). You can hide column A if desired.

Reply

Answer 3

Tor Lundgren Author

Level 2

263 points

Mar 30, 2014 8:48 PM in response to Badunit

Wow! OK, the 'scroll down' part was what fooled me. I'm going to go ahead and give them an 'F' for design on that panel, since the scroll bar no longer even shows up until you are hovering over it. Crazy stuff.

Thank you for figuring that out for me!

Reply

Answer 4

Tor Lundgren Author

Level 2

263 points

Mar 30, 2014 8:48 PM in response to YeOldMacFan

Nice! That is a clever approach, and thanks!

Reply