Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total back to w/c Monday
Hi,
I have a table of data that counts various items on a daily basis. The data is arranged in a table - Date - Item 1 - Item 2 - Item 3 etc I need to count the total as each week progresses from that weeks Monday. Can anyone advise on a formula to count each column total from the last Monday (date) in the table?. The forumla would ned to find the Monday of the current week and total the sum of each day of the current week. Cheers, Mickey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Sub total and totals | Excel Worksheet Functions | |||
Counting number of forwarding and sending back | Excel Discussion (Misc queries) | |||
Desperately need help with 3 calculations | Excel Worksheet Functions | |||
PivotTable-% of total | Excel Worksheet Functions | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) |