Calculate daily averages in a pivot table with weekly or other irregular periodic data

Charles Bushby

New Member
Joined
Aug 10, 2005
Messages
42
If I have this data in a list how do I calculate the average daily sales using weekly totals. The pivot table would give a result of 5.35 for January but I reckon it should be 4.42. Furthermore if the sales data were not weekly but irregular how would I then calculate the average daily sales?

Any help with this would be most appreciated.

Charles Bushby

DateSales per week
29-Dec-19​
40​
05-Jan-20​
50​
12-Jan-20​
30​
19-Jan-20​
20​
26-Jan-20​
50​
02-Feb-20​
2​
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Charles Bushby

New Member
Joined
Aug 10, 2005
Messages
42
I should add that I am trying to show the data by grouping monthly in a pivot table to show daily sales per month
 

Watch MrExcel Video

Forum statistics

Threads
1,118,140
Messages
5,570,400
Members
412,321
Latest member
Yusuf_A
Top