I’m a complete novice with “Calc” and would like to create a holiday “Rota or List” showing any year in two weekly allocations laid out like this:-
B 18/07/2020 to 01/08/2020
C 01/08/2020 to 15/08/2020
D 15/08/2020 to 29/08/2020
E 29/08/2020 to 12/09/2020
I’m sure there must be some simple way to achieve this and would be grateful if someone could enlighten me!
Hello @fsix-h, make a sketch as the file should be.
Correct, I’m wanting to insert the first date, and would like the rest to fill automatically for the entire year, however the layout you show would not be acceptable.
It needs to be arranged in columns as per the screen shot I have uploaded.
One year per vertical column set.
Sorry, I just don’t understand the proposed answer.
I wish to achieve a worksheet which is laid out exactly as per my example i.e.
each two week segment is shown as the starting date (to) the finishing date on one line.
successive two week segments on successive lines vertically, making each year appear as a column of dates as shown.
Ahh! just realised you had sent me a link!
Yes, I would very much like to be able to achieve either of your proposed solutions.
How did you do that!? 
Note: The yellow cells are to enter the initial date, they are with text in White.
Thanks Gilberto your link shiows me two options, the one I would like to be able to create would be your “Plan 2”.
Can you tell me how I can create sheets with this layout please?
@fsix-h,
If the answer met your need, please click on the ball 
to the left of the answer, to finish the question.
ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thankful.
Note: The yellow cells are to enter the initial date, they are with text in White.
Apologies if I am not putting my comments in the correct place to register for further help, I have repeated my last request below and hope you can show me how to achieve the output I need.
Thanks Gilberto your link shiows me two options, the one I would like to be able to create would be your “Plan 2”. Can you tell me how I can create sheets with this layout please?
Hi @six-h, follow new file in Plan3, copy the area A2: D30 and paste where you want. Enter the start date in B3.
