Excel for Mac - Pivot table grouping date by week

I'm trying to group dates by week within a pivot table (Excel for Mac). I know how to do this in Excel for Windows, but the interface is different. How do I go about this?
Answer
Answer
Hi Scott,

Right click on one of the date in the Date column of the Pivot Table, and select Group and Outline > Group.
 


Then select Days and enter 7 for Number of days.

 

Regards,
Jiaxing

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 15, 2024 Views 2,335 Applies to: