Average most recent 7 scores

Hello,

Attached is a sample of data for quality scores for my employees. We need an easier way to calculate a daily average based on the most recent 7 scores. The averages/employee could be on a different tab or the same, it doesn't matter. Any feedback would be great!

Thanks