G Guest Oct 27, 2004 #1 Using the autofilter on a column how can you autofilter dates? when you custome the criteria seems that * or ? does not work? Thanks
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 Oct 27, 2004 #2 Hi you can't use * or ? for dates as they're internally stored as values. What are you trying to achieve?
Hi you can't use * or ? for dates as they're internally stored as values. What are you trying to achieve?
D Dave Peterson Oct 27, 2004 #3 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.
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.
