Calculate a moving average

[Gib Montgomery]

I want to calculate moving averages on a large spreadsheet by adding a column
(BB) and deleting another (O), daily.
When I add new data by inserting a new column (BC) and deleting the old one
(O) my newest5 information is then in Column BB, but the formula for
averaging - originally written as =AVERAGE(O7:BB7) changes to
=AVERAGE(O7:BA7), and ignores the new column of data.
Manually changing the formula each time is a pain.
Every suggestion is welcome. My fingers are getting sore.

 

[Gary''s Student]

=AVERAGE(INDIRECT("O7:BB7"))

Immune to columns add/delete.

 

[מיכ×ל (מיקי) ×בידן]

This one will "provide the same merchandise":
=AVERAGE(OFFSET($O$7,,,,40))
Micky