Assume column J are your dates.

Select CUSTOM from the date drop down

Criteria:

is greater than or equal to ..... 1/1/2006
and
is less than or equal to ..... 12/31/2006
OK

--
Biff
Microsoft Excel MVP


wrote in message
ups.com...
Biff- This worked great!... Thanks so much. I don't know if you know
how to do this but I am trying to do an autofilter now under the
custom option to show me only the year 2006 termination dates. Do you
know how to do that b/c I'm having a real hard time attempting this.

-Anthony Morano