Help with daily schedule with auto days off.

Im trying to build a daily work schedule sheet.* One side will be the people at work, the other will be the people on a regular day off

Each line has a list box connected to an employee list,* *Doe, John* *(MT).

some will work with a trainee some will not.* The trainee are on a separate column.* *Column B is John doe* *(MT)* *and Column C is Trainee, jon* (TW).



I need to put a date on the daily schedule page, and that will determine if John gets moved to the other side of the sheet on a regular day off.* *I need this automatically and hopefully sorted by alpha for everyone off on that day.

Each sheet will be a new date.

Sunday May 14, 2023

WORK______________________________________________________________OFF

Truck 74* *Doe, John* *(MT)* Trainee, jon (TW) ________________________Smith, John* (SS)

TRuck 75* _______________________________________________________williams, bill* (SM)



Next day

Monday May 15,2023
WORK ___________________________________________ OFF

truck 74_________________Trainee, john (TW)_____________ Doe, John (MT)
truck 74 Smith, john (SS) _____________________________Williams, bill (SM)

just for clarification. There will be personal days off and other things on the sheet. IT will calculate the number of people there on that date and tell how many more can take off. Showing minimum staffing and such, but the above is the problem I cant figure out.
Basically a work schedule for the next day. It will tell them what truck they will be on so they know what route they will work and what time to report based on that route. I will make 7 separate sheets, one for each day of the week so they can plan ahead and see if there is room to take off that week.

ive got everything but the auto move of the regular days off. Trying to make it idiot proof for whoever makes the schedules.

Here is an example of what im looking for.... tfox6464

Since you're on 365, you have other options. I was unclear on exactly what you want, so I'm just going off of JeteMc is displaying.
On the Master, in C3, try:
=TODAY()+7-WEEKDAY(TODAY(),12)
(You could replace "TODAY()", with some date you wanted to reference.
For cells D3:I3, I just used:
=C3+1
For each day sheet, in cell B2, try:
=FILTER(Master!$A$5:$A$11,(INDEX(Master!$C$5:$I$11,,MATCH($E$1,Master!$C$3:$I$3,0))<>"x")*(Master!$J$5:$J$11=B1),"")
copy that to C2.
For Off days, try:
=FILTER(Master!$A$5:$A$11,(INDEX(Master!$C$5:$I$11,,MATCH($E$1,Master!$C$3:$I$3,0))="x"),"")

that works very well, thank you.... just gotta try to make it idiot proof on the entry of new employees...

Just tried that... and it said FILTER was invalid. Im trying to get plug that formula in to the orginal sheet by hand, adjusting for the real rows,
thanks for your help.. the master page works perfect

Who are you addressing this to? When you say, "Just tried that", just tried what? If you're saying the "FILTER" formula I mentioned in Post#6 was invalid, FILTER is valid on 365. If you're trying it on a machine that doesn't have 365, then it won't work.