View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlee Carlee is offline
external usenet poster
 
Posts: 155
Default 7 previous days average

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