Quote:
Originally Posted by Darkh0st
I really appreciate your response Wickedchew as it does work. However, it's averaging the entire column of data, and I would like it to average the past 30 days of data and shift everyday. Is this possible? Thanks again!
|
Let's say your table has the following information:
Column B has all the dates
Column C has all the data
Cell A1 has the start date to be averaged
Cell A2 has the end date to be averaged
=AVERAGE(OFFSET(C1,MATCH(A1,B:B,0)-1,0,(A2-A1)+1,1))
If you want it just plain 30 days from the start date:
=AVERAGE(OFFSET(C1,MATCH(A1,B:B,0)-1,0,30,1))