Hi Shams

You can do it with EasyFilter if you want
http://www.rondebruin.nl/easyfilter.htm

Or use AdvancedFilter with one formula in the criteria
=MONTH(A7)=1

See
http://www.contextures.com/xladvfilter02.html



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Shams" wrote in message ...
Folks,
Here's a snapshot of a column:

Date
Jan-04
Feb-04
Mar-04
Jan-05
Feb-05
Apr-05
Jan-06
Mar-06

This column is formatted as Date. I am trying to do a custom filter where
it will only pick up, for example, January related dates i.e. Jan-04, Jan-05
& Jan-06.

How do I do this? I tried to do a custom with the "Begins With" parameter
but it doesn't return anything. Is this because the column is formatted as
Date and the Begins with normally work with text fields? Please help.

Regards,
Shams.