Auto Filter
Maybe you can use a column of helper cells with formulas like:
=text(a2,"mm/dd")
or
=text(a2,"mm/dd/yy")
and filter on that.
Al wrote:
Column A has a range of dates go backwards through time to 1/1/1946. I want
to set up recuring values in columns B, C, D to track holidays and other
assorted info. I got to auto filter and set criteria to custom, contains,
10/31* for Halloween and it returns no values. Basically I want to be able
to filter to get all results for a specific date regardless of year.
How?
--
Dave Peterson
|