| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting an average of No of Days on board verses month departed.
Trying to figure out how to automatically avearge the number of days by the
month they dparted. I could manually do this each month by using the avearge function for instance =AVERAGE(H849:H880) but how can I set up a formula to avearge the total days based on the yyyymm of the detach date. Any help would be great. F G H Report date Detach date Total days 878 29-Aug-06 26-Sep-06 27 879 22-Aug-06 27-Sep-06 35 880 12-Sep-06 29-Sep-06 17 881 6-Sep-06 2-Oct-06 26 882 6-Sep-06 2-Oct-06 26 883 8-Aug-06 3-Oct-06 55 884 6-Sep-06 3-Oct-06 27 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
| Days per month for calculating storage days | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| formula for days in month - days left??? | Excel Programming | |||
Threaded Mode
