Filling schedule cell based on day of the week

BLUF: Trying to format auto-population of assigned work day based on day of the week

(See comment for image)

Building out a new work schedule that I don’t need to manually update for every month. I have a lot of it set (drop downs for assigned shifts, auto-generated calendar when I change month and year drop downs, etc). I’m trying to set it up so that when I change the month, it will automatically fill in the appropriate shifts when the days move. For example, Alpha Shift is on Sunday-Tuesday, so when I change months, I want the schedule to shift along with it.

I imagine I’ll take the same formula and adjust it for each of a shift’s rows. The following are if/then statements of the end goal:

IF “Sun” / “Mon” / “Tue” THEN “ALPHA”
IF NOT “”

IF “Thu” / “Fri” / “Sat” THEN BRAVO
IF NOT “”

I hope this paints the picture of my intent (as previously stated, actual picture below)

I’ve tried a bunch of different methods over the last couple days and have not found a solution. My google fu has failed me. Does anyone have any ideas?

BONUS: It’s shift work and the team alternates every other Wednesday. If there’s a way to incorporate that, it would be the icing atop the cake.

Please let me know if further explanation is required. I appreciate all your help.

Microsoft Excel for 365 MSO, Version 2604