Advanced Filter

[Dee]

I have a spreadsheet that has patients, doctors and
enrollment dates. I need to filter the data to find how
many patients were enrolled in a certain month. I don't
have a month column in my spreadsheet. Only dates like
08/12/03 and 08/15/03 etc. Can I use the advanced filter
to filter the month of august by using a formula and if
so what would the formula be. Could I have a criteria
that says "Between 08/01/01 and 08/31/03 to get all the
patients for the month of August 03.

Thanks in advance for your help.

Regards,
Dee

 

[Debra Dalgleish]

You can set up two columns in the criteria area. In both, use the same
heading as the date column. In the cell below, enter an operator and the
start or end date. For example:

Date Date

=8/1/03 <=8/31/03

There's a sample here:
http://www.contextures.com/xladvfilter01.html#Criteria

Or, you could use an AutoFilter, and select Custom from the dropdown in
the date heading.
For the first criterion, choose 'is greater than or equal to', and enter
the start date.
For the second criterion, choose 'is less than or equal to', and enter
the end date.