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
|