Hi All,
My husband has an 8 week rolling rota and I'd like to create a spreadsheet where he can enter in the year and it will automatically fill the dates he's working and off.
There are actually 8 teams, each with a different 8 week rolling rota so it would be good for a drop down to show the different groups data also.
I've been looking into for a few hours and can't find what formula's I need to be searching on in order to start it.
I have a spreadsheet where the dates are automatically populating dependent on 1 cell where I enter a start date.
Can anyone advise? It didn't seem like something that would be too complicated but I just can't wrap my head around it.
Many thanks in advance
Wintye
My husband has an 8 week rolling rota and I'd like to create a spreadsheet where he can enter in the year and it will automatically fill the dates he's working and off.
There are actually 8 teams, each with a different 8 week rolling rota so it would be good for a drop down to show the different groups data also.
I've been looking into for a few hours and can't find what formula's I need to be searching on in order to start it.
I have a spreadsheet where the dates are automatically populating dependent on 1 cell where I enter a start date.
Can anyone advise? It didn't seem like something that would be too complicated but I just can't wrap my head around it.
Many thanks in advance
Wintye