5 Day rolling average

First off, Can I just say that I am so glad there is a community like this out here! I have actually been using this forum for quite some time now as a reference, but I have come accross something that I havent been able to find a pheasable solution for. I need to take a 5 day rolling average of the 5 most recent entries for this table. They need to be separated by column, ex: the last 5 entries in column B currently average out at 122, but I cant get it so it automatically updates. I have been doing it manually every day, and its getting annoying. Does anyone have any Ideas? In row 2 I got it so it would find the last enry in the column, and I think I need to use that some how, but I cant get it to work. Any help is appreciated.

5 Load Dashboard MOD.xlsx

Well, after more playing, I think I got it!

Here is what I came up with

=AVERAGE(INDEX(B:B,MATCH(9.99999999999999E+307,B:B)-4):INDEX(B:B,MATCH(9.99999999999999E+307,B:B)))

Thanks,
That one works great too!