Help with setting up a shift schedule/roster!

Hi,
Thanks for the feedback but I think im on a different page, or Im may belost too :-) See attached link: http://skiftkalender.no/index.php?sk...=1&language=US

This is more or less what im looking for, but based on a starting date, to populate dates with highlights in a worksheet.

Sorry for any inconvenience

Hi again,

Still struggeling here so its time to bump this thread :-)

I have attached the current spreadsheet we are using for employees, a very time consuming rota and I want to have the ability to auto populate work ranges (with highlights) if possible.

This is based on a offshore work rotation, 2 weeks work and 4 weeks off with different traveldays, yes I know they are spoiled

Column A - employee number
Column B - Work location
Column C - Travel day (monday to friday)
Column D --> calendar and shift pattern, weeks!

For instance; Employee 1 (A12) I would like to pick a starting date and this will auto populate the work rota over the whole year! With highlight if possible


I am open to suggestions to change the layout and appreciate all the help I can get. Im kind of a novice user in Excel