another way without having to enter a date in cell a1 is


AVERAGE(OFFSET($C$1,COUNTA($B$1:$B$1000)-1,0,1,1):OFFSET($C$1,COUNTA($B$1:$B$1000)-8,0,1,1))

this assumes there is no data or dates below the last weeks dat

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=26903