Mar 08 2019 11:16 PM
Mar 09 2019 01:18 AM
Hi,
You need to add helper column first to your data which calculates weeknumber within the month. Let say firtst week of the month starts from first Monday and triggers to 1 on the first Monday of next month. One of techniques is here https://www.xelplus.com/reset-week-number-every-month-excel/
Creating the Pivot Table you add both Date and Week into rows pane and group Dates by months.
Mar 09 2019 01:31 AM