Excel: Grouping Dates in a Pivot Table By Week

This short video explains how to group a list of dates in a pivot table in Excel by week.

Connect with me via:

[ricardoarevalo]

When you spend hours looking for that one, little, piece of information that will solve all your problems... Ahhhh. Feels so good to finally find it. Much thanks, good sir!

[thefub]

Brilliant vid
Exactly what I want from a YouTube training vid
To the point, clear and no fuss

[adamchilds]

spent hours looking for this solution! Thank you

[goodvibespuno]

This is actually very simple and direct to the point. It really helps me alot as a beginner. Thanks!

[klordnh]

Thank you! This was short and sweet and perfect tutorial

[andrewchawda]

Awesome Mike to the point made my day !

[jigyasaajadoun]

Thank you so much sir it's really helpful for me 😢

[ithecs]

Thankyou for saving me after 5 years. ❤

[pancholitachiu]

This is exactly what I need, I will attempt on Monday on a Power Pivot

[ganeshkale]

One of the best tutorials of my life 😅, Short and Crisp

[LotfyKozman]

Can we create an equation thru the weeknumber formula that can create the week# for every month?

[alisonmitchell]

Thank you - simple and effective. A massive time saver. 😀

[chadhemmeline]

When i do this, I get a "cannot group that selection" error

[Booster_pack]

Now can you get the pivot chart to display the 7days as W1-W4 on the x-axis

[gsb]

O wow, you did an amazing job..thanks a lot

[johnbauer]

Is this a rolling 7 days or is it always this week?
Like if you say beginning of week is Monday then it'll give you dates between this Monday & Sunday or is it just past 7 days & if it's Wednesday then it'll give you from last Thursday to Wednesday.

[rifteeridmee]

But I want to identify the week number, how can I do this?

[balaramchampannavar]

How to group days without Saturday and Sundayss