Select the data table or at least have one of the cells in the table
selected, then:

Data Tab, Filter in the Sort & Filter Group, Click on the drop-down that
shows up next to data and Select "Text Filter", then "Custom Filter". From
here you should be able to select greater than and less than.

I hope this helps.

"ml" wrote:

I have a very a spreasheet data that looked like this...

Date Dept Q1 Q2 Q3
9/1/08 921 y n y
9/1/08 922 y y y
9/2/08 921 y y n
9/5/08 922 n n y

Right now I'm pulling the report by dept for all "y." If I want to pull the
same report but I want to pull it by specific dates (start and end date), how
do I do that? Help!

thanks