| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling Week
Day Date A B C D E T Tue 11.08.2009 6 6 0 0 0 12
Wed 12.08.2009 4 2 0 1 1 8 Thu 13.08.2009 6 0 0 2 0 8 Fri 14.08.2009 4 6 5 0 0 15 Sat 15.08.2009 0 0 0 0 0 0 Sun 16.08.2009 0 0 0 0 0 0 Mon 17.08.2009 5 0 0 0 0 5 I have a table similar to the one above. It is a 7 day working plan and is a rolling plan also e.g. after tues will go to the bottom for next week etc etc. I've managed to get the days and dates to "roll" by using the =TODAY() function annd +1 +2 etc but I was wondering if anyone could help me with the rest of the data? It would be great if the data would follow the day it linked to and the last days data all appear as zero. Anyone have any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate a 4 week rolling average | Excel Discussion (Misc queries) | |||
| How can I setup a rolling 13 week spreadsheet? | Excel Worksheet Functions | |||
| help with 12 week rolling average | Excel Worksheet Functions | |||
| Rolling 12 week calculations | Excel Worksheet Functions | |||
| Calculation using rolling 4 week amounts | Excel Discussion (Misc queries) | |||
Threaded Mode
