Rolling Average by Date

[PsyStal]

I am attempting to compile a worksheet that calculates a golf handicap based on the most recent 7 scores for each individual in my foursome.

One worksheet tracks the score breakdowns, with columns for name, date, individual holes, and totals for front/back 9 and 18.

I need the other worksheet to calculate the handicap for each golfer, taking into account only the data from their most recent 7 rounds, and allowing me to enter new rounds without entirely discarding old data.

Any suggestions?

[6StringJazzer]

If you post your file we can see how you are arranging your data, and can recommend how to capture the 7 most recent rounds. The data organization will affect the solution.