hi

in my sheet i have a cell that displays the month. below that i have the amount of days for that particular month. the following row holds standard values (a to c which depicts shifts) that is coloured. each shift is on for 7 days.

i want to the shifts to 'move' accordingly if the month is changed to the next month.

so looking at the sample workbook at the end of January shift B will only have worked 4 of their 7 days required, therefor February 1 to 3 will display shift B. then February 4 to 10 will display shift C, and so on...

any help is greatly appreciated.

in my sheet i have a cell that displays the month. below that i have the amount of days for that particular month. the following row holds standard values (a to c which depicts shifts) that is coloured. each shift is on for 7 days.

i want to the shifts to 'move' accordingly if the month is changed to the next month.

so looking at the sample workbook at the end of January shift B will only have worked 4 of their 7 days required, therefor February 1 to 3 will display shift B. then February 4 to 10 will display shift C, and so on...

any help is greatly appreciated.