Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the below list of days, and numbers corresponding to each day. I am trying to group the dates into weeks, with a total number for each week instead of each day. Is there any way to accomplish this?
03-Jan-12 Count 168 04-Jan-12 Count 193 05-Jan-12 Count 175 06-Jan-12 Count 101 09-Jan-12 Count 119 10-Jan-12 Count 64 11-Jan-12 Count 82 12-Jan-12 Count 68 13-Jan-12 Count 45 16-Jan-12 Count 115 17-Jan-12 Count 33 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
Pivot Table Group by Week? | New Users to Excel | |||
group sales by week and week number | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Pivot table - group dates per week or month | Excel Discussion (Misc queries) |