Glad to hear that Carlee!

Regards
Martin

"Carlee" wrote in message
...
it worked !! It worked!! It worked!!!

Thank you so very much for all of your help.
--
Carlee


"MartinW" wrote:

Hi Carlee,

Unless I'm missing something here (quite probable!)

All you need to do is put this in AK9
=IF(AJ9="","",AVERAGE(AJ3:AJ9))
and drag it down as far as your future needs require.

The references update as you drag to give you
a rolling 7 cell average.

HTH
Martin


"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