Pivot table and counting stores by multiple activities by date

You'll need to convert your data layout - is that going to be a problem?

Something like the attached.

I created a new column next to your date columns that simply concatenated the first three columns using a pipe separator - i.e. the formula was just:
=A2&"|"&B2&"|"&C2
I then used the pivot table wizard (Alt+DP to invoke it) and chose to create a pivot table from consolidation ranges, and selected the option to create the page fields myself. I added the formula column and the date columns as a range (in other words, skipping the first three columns), and chose 0 page fields, then created a new pivot table. I then double-clicked on the Grand Total field to create a table in the format required and finally used Text to Columns to split the delimited formula column created in the first step back into separate columns.
It's basically this technique with an addition step to create the multiple columns at the start: https://www.youtube.com/watch?v=xmqTN0X-AgY