Ask Your Question
0

How do I create an annual fortnightly holiday rota commencing on Saturdays?

asked 2019-05-06 18:59:29 +0100

six-h gravatar image

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!

edit retag flag offensive close merge delete

Comments

Hello @fsix-h, make a sketch as the file should be.

Schiavinatto gravatar imageSchiavinatto ( 2019-05-06 19:28:51 +0100 )edit

This is a similar page

six-h gravatar imagesix-h ( 2019-05-06 20:18:23 +0100 )edit

Sorry, I did not understand.

You want to fill in column B and the rest to be automatic.

image description

Schiavinatto gravatar imageSchiavinatto ( 2019-05-06 20:35:40 +0100 )edit

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.

six-h gravatar imagesix-h ( 2019-05-06 20:46:23 +0100 )edit

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!? :D

six-h gravatar imagesix-h ( 2019-05-06 22:23:31 +0100 )edit

Note: The yellow cells are to enter the initial date, they are with text in White.

Schiavinatto gravatar imageSchiavinatto ( 2019-05-06 22:46:46 +0100 )edit

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?

six-h gravatar imagesix-h ( 2019-05-07 19:16:45 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-05-06 22:06:26 +0100

updated 2019-05-06 22:07:11 +0100

@fsix-h,

Segue arquivo com dois exemplos....


If the answer met your need, please click on the ball Descrição da imagem 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.

edit flag offensive delete link more

Comments

Note: The yellow cells are to enter the initial date, they are with text in White.

Schiavinatto gravatar imageSchiavinatto ( 2019-05-06 22:46:45 +0100 )edit

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?

six-h gravatar imagesix-h ( 2019-05-07 19:50:43 +0100 )edit

Hi @six-h, follow new file in Plan3, copy the area A2: D30 and paste where you want. Enter the start date in B3.

Modified file.

Schiavinatto gravatar imageSchiavinatto ( 2019-05-07 20:53:01 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-06 18:59:29 +0100

Seen: 31 times

Last updated: May 06