How to group dates in Excel Pivot Table by Weeks

Question

When I attempt to group my dates by days to show weeks the fields are grayed out.

Answer 1

Hi @Anonymous

You will need to remove any record that has N/A in the filtering (or any record that does not follow the proper date structure.

Once you have done this the capability to choose days will no longer be greyed out. Then you can choose 7 days (which will be you week filter).

-----------------------------------

If this is helpful please accept answer.

Answer 2

I have done all that and still have the grayed out boxes.

Answer 3

Hi,

Are the date columns formatted in correct date format? If they’re not, they won’t allow grouping, filtering or any other date related function.

----------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept as answer--

Answer 4

Yes. All dates are in the Date Format.

Answer 5

Hi, @Anonymous
Have you tried to refresh the pivot table after the change? Whether excel is up to date, it is recommended that you update to the new version.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.