Try this...

Use cells to hold the criteria.

A1 = name to count for
B1 = lower date boundary
C1 = upper date boundary

Then:

=SUMPRODUCT(--(name_range=A1),--(date_range=B1),--(date_range<=C1))

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
In a sheet I have activities completed by specific staff on specific date.
I
want to countthe number of times the activity occurs within each month (a
date range i.e. 05/01/10 through 5/31/10). For each instance that the
specific staff memebr completes the activity their name appears adjacent
to
the date the activity was completed. The dates are not in chronological
order, thus the need to be able to search and find each date within the
date
range and to count how many times the specific staff member's name appears
within that date range.
--
John