Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default Rota Projection

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
forecast or projection Dena J Excel Worksheet Functions 0 March 16th 07 07:39 PM
Month End Projection formula? sueshe Excel Worksheet Functions 8 November 28th 06 02:13 PM
Rota chris.howes Excel Discussion (Misc queries) 1 July 24th 06 12:30 PM
Projection of values call_Vishwa Excel Worksheet Functions 0 May 8th 06 11:23 AM
dealing with a projection Larry Holt Charts and Charting in Excel 0 February 15th 06 04:03 PM


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"