Rolling four week avg. - Excel 2010

[Huzzah]

Hi, I'm hoping someone can help me. I'm trying to automate a rolling average that will always average the four most recent data points based on the date.

I have attached the file. The run rate average is in cell A2 and the next weeks data will be added to the next empty column (O).

Thanks,
Steve

[Huzzah]

Please ignore, I thought I was making a new post. Newbie error

[Cutter]

Maybe this

=AVERAGEIF(B1:N3,">="&MAX(B1:N3)-21,B4:N4)

[Huzzah]

Maybe this

=AVERAGEIF(B1:N3,">="&MAX(B1:N3)-21,B4:N4)

Using this method won't I have to change the fomula when I add the next weeks data in column O? Is there a way to reference the entire rows for the date and data and only average the four highest data values?

[Cutter]

Just change the column range to the max which is XFD so

=AVERAGEIF(B1:XFD3,">="&MAX(B1:XFD3)-21,B4:XFD4)

[Huzzah]

Just change the column range to the max which is XFD so

=AVERAGEIF(B1:XFD3,">="&MAX(B1:XFD3)-21,B4:XFD4)

DUH!! Fantastic, thank you so much.