=countif(A:A,"=5/22/05")-countif(A:A,"5/28/05")

--
Regards,
Tom Ogilvy

"Bill" wrote in message
ink.net...
Hello,
I have a column of dates (e.g.,5/25/05, 5/26/05) that are used to record
when a complaint comes in. I would like to determine the number of
complaints each week (Sunday thru Saturday). When there are no complaints
in a week, I would like to enter zero. So, I end up with a columns:

Week Starting Num of Complaints

Is there an easy way to do this? I can add the week number to a couple,
add
up the week numbers, but I don't get the weeks when there are no
complaints.

Thanks,

Bill