I was preparing weekly schedule/roster for my team and I needed to alternate the schedule between two groups on a weekly basis, i.e. 7 days from first Sunday in 2016 to the last Sunday in 2016. I accomplished the task by auto adding 7 days to column first Sunday column.
Below was the steps I followed to accomplished the task.
1. First I created the date and the group columns, i.e. A and B cells
2. On the Date column (A2), I entered the first Sunday i.e. 03/01/2016
3. In cell A3, I entered =A2 + 7 and pressed enter, this produced the date 10/01/2016
4. I selected the cell A3
5. I then moved the cursor to the lower right hand corner of the cell A3. Note, at the lower right corner, the cursor should changed to plus sign(+)
6. I then dragged the cell down to cell A55, i.e. until the last Sunday of the year – 25/12/2016
[asa2 tpl=”Book”]111907715X[/asa2]
