# Thread: help creating working schedules

1. ## help creating working schedules

Hello,

In my work i have to make weekly working schedules for my co-workers.

Almost all of them are part time workers and have a first main job.

I have 2 or 3 cases that they have a rotating schedule on their first job but it's always the same:

example

day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15....
schedule A A A B B C C C F F A A A B B....

A- 08:00-16:00
B 16:00-24:00
c- 24:00-08:00
F- day off

So i know what the schedule that they will make on the other company, but i just want that to fill automaticaly on my own schedule when i insert the day of the month.

Can anyone help me with this tricky formula?

2. CROSS POST

This question has been posted in at least one other forum.
Do not post any further responses in this thread until a link has been provided to these cross posts.

Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
Please provide the link(s). If you are unable to do so, tell us where else you have posted this query.

3. If I understood you well, use the VLOOKUP function

4. Originally Posted by navic
If I understood you well, use the VLOOKUP function

The thing is what about day 16 or 2 months from now? I want to know what schedule he does on the other job without having to count days or wasting time.

what i tought was if he in 01/05/2019 is doing the A schedule, on the day_x will be =day_x - 01/05/2019 and that number will correspond to a posicion on his other schedule (A,B,C...).

1st sheet set your example situation
2nd sheet same situation with expected result

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•