One last question, the end result is off by one week. For example, if 9/16, the results starts counting from 9/16 and 4 previous weeks (which is 8/26, 9/2, 9/9, 9/16). Is there a way where the formula would actually start to count the week before? So if someone chose 9/16, the rolling 4 week average would include weeks of 8/18, 8/26, 9/2, 9/9? It would not include the 9/16 results...make sense?
Sorry if I am making it a little more complicated, but the original formula above did this....Thank you in advance for your help. I TRULY appreciate this.




Reply With Quote
Bookmarks