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.