Why can't I auto filter date fields?

  • Thread starter Thread starter Spalding
  • Start date Start date
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"
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Filter Help 2
Auto filter for multiple columns 2
Can I use "OR" in two auto-filters/custom filters? 1
Auto Filter 5
MS Query - Filtering all dates greater than the current date 1
Custom filter date using VB 1
Filter for a symbol 1
Limit filter options in Auto Filter 1

Back
Top