Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
We have a rolling 5 week rota with a week starting on sunday an example of
which is shown below. Sun Mon Tue Wed Thu Fri Sat 1 Rest Rest A2 A2 A2 A2 A2 2 Rest A1 A1 A1 A1 A1 Rest 3 Rest B2 B2 B2 B2 Rest B1 4 B1 B1 B1 Rest Rest B2 B2 5 B2 B2 Rest B1 B1 B1 Rest Our pay period is every 4 weeks and a duty statement is submitted for this period. What I would like to do is that given a start date of the rota is to be able to enter a future date and to have my duties for the 4 next weeks to be displayed. Any help would be really appreciated. -- Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
forecast or projection | Excel Worksheet Functions | |||
Month End Projection formula? | Excel Worksheet Functions | |||
Rota | Excel Discussion (Misc queries) | |||
Projection of values | Excel Worksheet Functions | |||
dealing with a projection | Charts and Charting in Excel |