Quote Originally Posted by Ashraf1
...would only need 7 days ie sun to sat. Pivot to show count of changes on Mondays;Tues etc for a month.
I'm not sure I made my earlier point very well.

If you have greater than a weeks worth of transactions (ie > 7 days) then your approach won't work.

You can not (AFAIK) group a Pivot Table by the Weekday (Mon, Tue) of the underlying Date values.

You will need to create an additional column at source that stores the weekday [=TEXT(date,"ddd")] by transaction and use that new column as the Row Label in your Pivot.