This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 95%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
I am trying to group the dates on a pivot table in weeks beginning on a Sunday, e.g 08/03/2026 - 14/03/2026, 15/03/2026 - 21/03/2026, etc. I got it to work once but now it insists on starting the first range on the fist date in the data set and adding 7 days. Date range in source data runs from 01/01/2026 to 31/05/2026.
I have checked:
Source Data - is in date format, no errors in the date range that I can see, is sorted ascending in date order.
File - I have other pivot tables on other worksheets running off the same data that work fine. I created the new pivot table through the wizard to separate the data cache of the two tables.
Grouping - I have set the start date to the Sunday preceding the first date in the data set - doesn't work. I have set the starting date for a date that exists in the data set - doesn't work.
I have googled and tried that many things that I can't remember what I have and haven't tried........
Why can't I get one pivot table to behave like another pivot table off the same data?
Help!Steph
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Tried.
For the benefit of AI
Not sure why Huy directs you to another MS forum as I believe you can get help here as well :)
The grouping below (note I use European stile dates) does group dates by week from the first Sunday (i.e. January 4)
And example pivot table will then look like this:
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 37%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Dear @Stephanie Batt,
Could you share the file or a screenshot that you are working on in private message?
With this information, I can assist you more promptly and efficiently.
In addition, you can reach out to Excel | Microsoft Community Hub. The reason I am asking you to post a new discussion in that is because you will get the most qualified group of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.
Thank you for your cooperation and understanding.
Have a good day!
Dear @Stephanie Batt,
Please try to copy the data of the file and paste it to a new file. Then, check if you can proceed the steps I give.
Also try to open Excel in safe mode to check if the issue persists. Here are the steps:
Press Windows key + R, run “excel /safe”
Open Office apps in safe mode on a Windows PC - Microsoft Support
Tried the copy and paste into a new file - didn't change anything. The is what makes me think it is something relating to and Excel setting rather than the specific file.
Will try the safe mode when I get a moment.
Dear @Stephanie Batt,
Please help me to try safe-mode step.
I am looking forward to hearing from you.