Average If by Current week
I'm trying to figure out the formula to calculate the average of a column based on the current week.
I do have a week column.
I tried this but it didn't work :(
=AVERAGEIF([Created Week]:[Created Week],TODAY,[Overall Satisfaction]:[Overall Satisfaction])
And then... I'm also looking for the average for the PREVIOUS week.
Help Article Resources
Check out the Formula Handbook template!