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?

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

The dates are stored as serial numbers, so your 10/31 won't work. Try a
helper column, for example =DAY(A1)&"/"&MONTH(A1), or =TEXT(A1,"dd/mm"), and
then you can auto-filter on that column.
--
David Biddulph

"Al" wrote in message
...
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?

I need to be able to do this for data entry purposes though so I need column
A to match up with the right cells in B, C, D, etc...

I'm not sure I understand what you guys are saying by using the helper
cells... Sould I set up the formulas in columb b to basicaly translate that
informatoin into text?

"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?

select in your column A with dates

formatcellsnumberscustommmm-d

10/31 will be viewed as Oct-31

then you can use autofilter

happy holidays

"Al" wrote:

I need to be able to do this for data entry purposes though so I need column
A to match up with the right cells in B, C, D, etc...

I'm not sure I understand what you guys are saying by using the helper
cells... Sould I set up the formulas in columb b to basicaly translate that
informatoin into text?

"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?

Yep. But you can use any column you want (insert a new column B or go to the
first unused column).

Al wrote:

I need to be able to do this for data entry purposes though so I need column
A to match up with the right cells in B, C, D, etc...

I'm not sure I understand what you guys are saying by using the helper
cells... Sould I set up the formulas in columb b to basicaly translate that
informatoin into text?

"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