| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining weekday formula, average and going back 7 cells
I am trying to get a weekly average from a temperature column. The excel
spreadsheet has a months worth of dates and an average for each day. I found the weekday formula and can convert weekdays to a number from 1 thru 7. From that I want to use the IF logic formula that day 7 it would average backwards 7 days (cells). There might be an easier way to do it but getting the syntax right is also a problem. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a formula combining 2 cells into a % | Excel Discussion (Misc queries) | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| Need to bring back Average using either Sumproduct or CSE formula | Excel Discussion (Misc queries) | |||
| average based on weekday | Excel Worksheet Functions | |||
| Combining today +1 and weekday function | Excel Worksheet Functions | |||
Threaded Mode
