| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for generating monthly & weekly averages
I have a running list of dates in column A, but there are some missing dates.
There is associated data in column B. I'd like to put weekly averages (Week is Sunday-Sat) in column C and monthly averages in column D. I can't just fill down a pattern of every 7 or 30 days, because of the missing days and the fact that not all months have 30 days. Can you help me generate functions that will do this? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| OFFSET function to pick up monthly groups of data | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
