Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have been working on this for a little while now and can't seem to grasp
the right formula to use. I have columns of data sorted by name to be tracked daily. I need to then give my boss the information so she can not only see it daily and monthy which I have figured out - but wants to see weekly as well and thats where im stumped. The formula I am using to get the week number populated works great and is =WEEKNUM(Table1[[#This Row],[Ddate]]) What I need to do is get totals from "Table2" to "Table3" into a weekly format instead of daily. So in essence everything that says week 1 next to it - totaled onto table3 in tab 2. Any input on this delema would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting daily data into weekly, monthly and yearly data | Excel Discussion (Misc queries) | |||
Converting daily data into weekly | Excel Discussion (Misc queries) | |||
Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
How can I calculate weekly totals of daily data in Excel | Excel Worksheet Functions | |||
Daily data to weekly data conversion in Excel? | Excel Worksheet Functions |