Filters

[Guest]

I have 3 columns of dates ( MM/DD/YYYY) from 2000 to say 2010. How do you
display ( filter) only the year 2000 ?? 2007 ?? etc.
Thanks,
Clint E.

 

[Dave Peterson]

If you're only filtering by a single column, you could use Custom and then
filter to show all the dates greater than or equal to January 1, 2000 AND less
than or equal to December 31, 2000.

If you wanted to see the rows where any of the fields was in 2000, then you
could insert a new column and fill it with a formula that looks like:

=((year(a2)=2000)+(year(b2)=2000)+(year(c2)=2000))>0

This will return a true (if any of the years were in 2000) or false (if all the
years were not in 2000).

Then drag the formula down the rows you need and filter to show the True's.

 

[Guest]

Thanks Dave. Don't think I needed the ">0" though.
Clint

 

[Dave Peterson]

If you want to filter by true/false, you'd want the >0.

If you were going to filter by 0 or non-zero, you wouldn't need it.