Pivot Table Date Group by Week

[peazmo]

hey guys, i want to group the dates by WEEK on my pivot table but excel 2010 don't have group by week.
i refrain to use DAYS then 7 because the start and end dates appear. i want it more presentable like WEEK 1, WEEK 2.. so on
if i add WEEK column on my table, some weeks will be missing if i don't have that data.
i want to have complete WEEK 1 to WEEK 52. anyone can help???

 

[Derek Brown]

Have a look at the following for an idea:
http://www.youtube.com/watch?v=R2XAQhyiV24
The technique seems to work in Excel 2010 grouping by "7" days so may work OK if you use the same technique with a 'Week' column added?

 

[tmagdy]

hey guys, i want to group the dates by WEEK on my pivot table but excel 2010 don't have group by week.
i refrain to use DAYS then 7 because the start and end dates appear. i want it more presentable like WEEK 1, WEEK 2.. so on
if i add WEEK column on my table, some weeks will be missing if i don't have that data.
i want to have complete WEEK 1 to WEEK 52. anyone can help???

Add another column next to your dates and add Weeknum function point to these dates to provide you with the weeknumber.
You need to apply option 1 or 2 whether you want week to start on Sunday or Monday.
Create your pivot again with both the date and the week number in your row labels.
If you then group the dates on years, it will then properly sort all the week numbers sequentially and properly grouped by year.