autofilter dates

E

Ego

Using the autofilter on a column how can you autofilter dates? when you
custome the criteria seems that * or ? does not work?
Thanks :)
 
F

Frank Kabel

Hi
you can't use * or ? for dates as they're internally stored as values.
What are you trying to achieve?
 
D

Dave Peterson

If I want to see the data between two dates, I use the Custom Filter.

And then use greater than (date1)
and less than (date2)

(use the dropdown to select date1 and date2--or even type them!)

If I want to see the data for a certain Month (across years), I'll insert a
helper column and use a formula like:

=month(a2)

And filter on that.
 
Top