I have a rather large Excel file (database) that I need to count by quarter. For example: xx number of people called during the 1st Qtr, xx in the second Qtr, etc. I tried using the COUNTIF function, but the criteria for this function doesn't accept a range of dates (or I can't get the syntax correct). I need, for instance, "count this row if 'call date' is between 10/01/2000 and 12/31/2000".
I am running Excel 97.
Data Management Specialist