8 week rota is it possible to move the weeks forward so week 1 ROTA moves to the week 8 position and week 2 moves to week 1 position
but by the month updating it would need to move forward by 4 weeks
8 week rota is it possible to move the weeks forward so week 1 ROTA moves to the week 8 position and week 2 moves to week 1 position
but by the month updating it would need to move forward by 4 weeks
Not really sure what you are asking.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
rough example
January
M T W T F S S across for the month
Names L L O O O N N FOR WEEK 1 ROTA
ON SPREAD SHEET IF JANUARY GOES FORWARD A MONTH TO FEBUARY
M T W T F S S
NAMES L L O O O N N AT PRESENT THIS WOULD STAY THE SAME
BUT I WOULD LIKE IT TO ADVANCE 4 WEEKS TO READ
M T W T F S S
NAMES M M L L O O M WHICH WOULD BE WEEK 4 OF AN 8 WEEK ROTA
Last edited by rds2472; 10-16-2009 at 04:31 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks