Taking Weekly Average Every Friday.
I have a spreadsheet, on this sheet I have some values I would like the average of as well as dates assigned to these values. Taking the average is not the only thing I need to do, I need to take the average of these values, grouped by week, from Friday to Thursday. Meaning I have to find a way to group the values by week given just their dates, then I must further modify it so the 7 days recorded are from Friday to Thursday, I THEN need to return the average of those values. If anyone could suggest to me any kind of way I can do this, I would really appreciate it, any help is useful. I will provide some mock data below, as well as some mock results that would be ideal.
*Note: The average is the days to complete over the amount of days recorded in that week, shown as the count.
Help Article Resources
Check out the Formula Handbook template!