Thread: Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_30_] Bill[_30_] is offline
external usenet poster
 
Posts: 89
Default 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