mtagliaferri
Board Regular
- Joined
- Oct 27, 2004
- Messages
- 156
I have a shift planner which I populate days OFF with the letter 'O and it formats the cell colour to blue.
I would like to populate the row with a specific patter of 28 days which is 5 On, 5 Off, 4 On, 5 Off, 5 On, 4 Off, therefore when the patter is OFF I would like to populate the cell with the letter 'O'
more specifically I need this pattern to be able to start from the selected cell and populate the rows from there onwards and for the remaining sheets.
E.G in the sheet October if I start from the 3rd which is F7 I need to start the pattern from that cell till end of October (Cell AH7) and then continue with the pattern in November (D7 - AG7) and then December (D7- AH7). If I start from January then it will populate all sheets to December.
The difficult part is the leap year, the sheet populates the calendar section based on the year, therefore I have the additional column in February in order to accommodate the leap year.
Any thoughts if this is achievable? If so how?
I would like to populate the row with a specific patter of 28 days which is 5 On, 5 Off, 4 On, 5 Off, 5 On, 4 Off, therefore when the patter is OFF I would like to populate the cell with the letter 'O'
more specifically I need this pattern to be able to start from the selected cell and populate the rows from there onwards and for the remaining sheets.
E.G in the sheet October if I start from the 3rd which is F7 I need to start the pattern from that cell till end of October (Cell AH7) and then continue with the pattern in November (D7 - AG7) and then December (D7- AH7). If I start from January then it will populate all sheets to December.
The difficult part is the leap year, the sheet populates the calendar section based on the year, therefore I have the additional column in February in order to accommodate the leap year.
Any thoughts if this is achievable? If so how?