Hello.

I'm looking for a formula to average data by week number.

For example: Week 23
06/01/2011= 99%
06/02/2011= 100%
06/03/2011= 100%

Week 24
06/06/2011= 100%
06/07/2011 = 95%

I need a formula to average the daily results within an assigned week number.