LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 8
Question Group Dates by Week?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert regular Date to Week Ending or Week Beginning Dates Sam H Excel Discussion (Misc queries) 5 April 3rd 23 04:39 PM
Pivot Table Group by Week? DTTODGG New Users to Excel 5 September 6th 07 01:40 AM
group sales by week and week number Wanna Learn Excel Discussion (Misc queries) 7 November 7th 06 11:44 AM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 03:54 PM
Pivot table - group dates per week or month digicat Excel Discussion (Misc queries) 1 January 8th 06 08:46 PM


All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"