Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have three columns of data as shown below, but for the entire year:
A B C 08/01/06 Tue 2999.78 08/02/06 Wed 3283.59 08/03/06 Thu 1516.91 08/04/06 Fri 2108.34 08/05/06 Sat 2035.85 08/06/06 Sun 3972.03 08/07/06 Mon 2949.30 I need a formula that can calculate the average daily revenue by the day of week, so for year I would know the average daily revenue by Tuesdays or Thursdays, etc. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Desperately trying to build a paid time off accrual worksheet... | Excel Worksheet Functions | |||
update week to week in excel. | Excel Worksheet Functions | |||
Applying days of the week to dates | Excel Discussion (Misc queries) | |||
Number of Week Days _including_ Holidays | Excel Worksheet Functions | |||
selecting days of week using a formula in spreadsheets | Excel Worksheet Functions |