Change column to suit

=AVERAGE(OFFSET($F$1,COUNT($F$1:$F$1000),,-7,))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Carlee" wrote in message
...
Hi All,

Question: What function can i use to create an average value of the
previous 7 days?

Column AJ contains data, which is added to everyday
Column B contains the date

In Column AK, I want to have a value, which calculates the average value,
of
the 7 previous values entered in column AJ.

Data starts in row 3 for all columns.
--
Carlee