Hi
I have the following formula, which is calculatin a 5 weeks average.
=AVERAGE(INDEX(AU3:BK3;;MATCH(TODAY()-WEEKDAY(TODAY();3)-3;AU$1:BK$1;0)-MIN(5;MATCH(TODAY()-WEEKDAY(TODAY();3)-3;AU$1:BK$1;0))+1):INDEX(AU3:BK3;;MATCH(TODAY()-WEEKDAY(TODAY();3)-3;AU$1:BK$1;0)))/40
I now have to change it in the way, that the 5 week average is going to be taken from Today's date minus 12 days.
Would it be possible to do that? I have tried to change it a bit, but unfortunately, I was not able to do it myself.
Thank you very much for your help
Roman
I have the following formula, which is calculatin a 5 weeks average.
=AVERAGE(INDEX(AU3:BK3;;MATCH(TODAY()-WEEKDAY(TODAY();3)-3;AU$1:BK$1;0)-MIN(5;MATCH(TODAY()-WEEKDAY(TODAY();3)-3;AU$1:BK$1;0))+1):INDEX(AU3:BK3;;MATCH(TODAY()-WEEKDAY(TODAY();3)-3;AU$1:BK$1;0)))/40
I now have to change it in the way, that the 5 week average is going to be taken from Today's date minus 12 days.
Would it be possible to do that? I have tried to change it a bit, but unfortunately, I was not able to do it myself.
Thank you very much for your help
Roman
