Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |