Solved: calculate average for past 7 days - Page 2

kfschaefer · ‎04-21-2016

Is there a function to calculate the (current date-1)-7 to display the average over the past 7 days not including current date?

If 4/21/2016 then 4/20/2016-7 days for the average of the Revenue for those dates.

day Revenue

1 25000

2 50000

3 23000

4 14000

5 14000

6 18000

7 5000

so the average = 21285.71

thanks,

K

Sean · ‎04-22-2016

@kfschaefer Just a final friendly warning.

The way you have it setup in Excel AVERAGE is not giving you divided by 7 in ALL cells!

Create a separate column and see for yourself => check manually => add the 7 Revenues and divide by 7 (write /7)

do this for all your dates => let me know if you get the same Averages as AVERAGE( ) is giving you?

calculate average for past 7 days