Average last seven entries in a row

[SimonHughes]

Hello, I need a formula that will automatically update the last seven entries in a row of data. Data is added on a daily basis so today I need the average of C4 to I11 and tomorrow from C5 to I12

Using Excel 2016

Many thanks in advance

 

[shaowu459]

please see if this helps:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3
4			1	1	1	1	1	1	1		1.19
5			1	1	1	1	1	1	1
6			1	1	1	1	1	1	1
7			1	1	1	1	1	1	1
8			1	1	1	1	1	1	1
9			1	1	1	1	1	1	1
10			1	1	1	1	1	1	1
11			1	1	1	1	1	1	1
12			1	1	1	1	1	1	9
13
Sheet1

Cell Formulas
Range	Formula
K4	K4	=AVERAGE(OFFSET(INDEX(C:I,LOOKUP(1,0/(C:C<>""),ROW(C:C)),),,,-6,))

 

[SimonHughes]

Thanks but this formula is static. As I enter the data the new column the formula must shift as well. So the formula must give the average of C4 - I4 today, D4 to J4 the tomorrow day, E4 to K4 the following day and so on.
Sorry for not making this clear.

 

[shaowu459]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3
4			1	1	1	1	1	1	1	1	2
5
6
7				1.166667
8
9
Sheet1

Cell Formulas
Range	Formula
D7	D7	=AVERAGE(OFFSET(INDEX(4:4,COUNTA(4:4)+2),,-5,,6))

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3
4			1	1	1	1	1	1	1	1	2	3
5
6
7				1.5
8
Sheet1

Cell Formulas
Range	Formula
D7	D7	=AVERAGE(OFFSET(INDEX(4:4,COUNTA(4:4)+2),,-5,,6))

 

[SimonHughes]

That works perfectly, many thanks indeed. I just changed the array to read C4:ZZ4 as I wanted the results in column B.
Once again, thanks for taking the time to help.

 

[shaowu459]

That works perfectly, many thanks indeed. I just changed the array to read C4:ZZ4 as I wanted the results in column B.
Once again, thanks for taking the time to help.

You are welcome