If you are actually putting quotes around the date string, Excel will
interpret it as a word, instead of translating it into a date.

Try using this:
Is greater than or equal to
And just enter: 7/1/2006

Is less than or equal to
And enter: 7/31/2006

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"elephant" wrote:

I tried to use "contain" "Jul-06"

"begins with" "01-Jul-06" and "ends with" " 31-Jul-06" but still can't get it.