Use AutoFilter with Formatted Dates

[BradP]

Is it possible to use this function when you are working with dates?.
have been able to use it when I enter the month and date but not whe
that cell or column has been format for Dates.

-Example- :

Jan. 1, 04 - Typed in - Work fine

Jan 1, 2004 - Formatted mmm.d, yy - Does not work

AutoFilter was customized by: begins with J

Any suggestions?

 

[Frank Kabel]

Hi
dates are internally stored as numbers. You may add a helper column
like
=TEXT(A1,"MMM")
and use this helper column for filtering

 

[BradP]

Thanks for you hel