| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of previous values | Excel Discussion (Misc queries) | |||
| Average based on the previous row | Excel Worksheet Functions | |||
| Subtract # of days from date, but if not sat, goto previous sat? | Excel Discussion (Misc queries) | |||
| 25 days previous to today? | Excel Discussion (Misc queries) | |||
| date functions for previous 60/90/180 days | Excel Worksheet Functions | |||
Threaded Mode
