Why can't I auto filter date fields?

S

Spalding

With a column of dates like 5/5/2004 13:20, the only thing that works i
to select a specific date from the drop down. Trying contains 5/ o
anything similar doesn't work, it returns nothing at all.

Also, would there be any way to change the default choice on aut
filter from "equals" to "contains"
 
D

Dave Peterson

Are you looking to filter on months or days?

You might be able to use custom and "greater than" and "less than" combinations.

But sometimes, I'll just insert a new column and put a formula like:

=month(a2)
or
=day(a2)
or
=year(a2)

Drag down and filter on that.
 
Top