Dates
 

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

Dates
 

=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

Dates
 

Put the dates in B1, C1, etc

In B2, enter

=SUMPRODUCT(--($A$1:$A$1000=B1),--($A$1:$A$1000<B1+7))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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