7 Day Average/30 Day Average
I am trying to build a formula for a data set that I can calculate as a complete average, but I'd like the 7 day average and the 30 day average.
Here's the formula that works: =AVG([% Successful]:[% Successful])
I know I will need to use AVERAGEIF, but can not get the date parts correct.
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!