Guidance with employee shift schedule

*The input sheet requires some 'cleaning':
- The shifts are only on 'Sundays', 'Mondays' and 'Wednesdays'.
- It would be simpler if it would automatically remove the unnecessary days, or simply auto-create a monthly table with the 3 days only

Cell A1 is populated using data validation that references the list of months in column AL
Cell A2 is populated using: =INDEX(AM2:AM13,MATCH(A1,AL2:AL13,0)) and is custom formatted yyyy
Cells B1:AC1 are populated using: =IF(WORKDAY.INTL($A2,COLUMNS($A1:A1)-1,"0101110")>EOMONTH($A2,0),"",WORKDAY.INTL($A2,COLUMNS($A1:A1)-1,"0101110")) and are custom formatted ddd, d
Cells B2:AC2 are populated using : =B1 and are custom formatted d
Let us know if you have any questions.

As to somewhat automating the output sheet:
1. Populate A1 using: =input!A2
2. Populate A2 and down using: =IF(WORKDAY.INTL(A$1,ROWS(A$1:A1)-1,"0101110")>EOMONTH(A$1,0),"",WORKDAY.INTL(A$1,ROWS(A$1:A1)-1,"0101110"))
3. Populate columns B:C using: =INDEX(input!$A$3:$A$25,AGGREGATE(15,6,(ROW(input!$A$3:$A$25)-ROW(input!$A$2))/(input!$B$1:$O$1=$A2)/(input!$B$3:$O$25=2),COLUMNS($A$1:A$1)))
Note that the person making out the schedule will need to type the number 2 in the correct employee row/date column on the input sheet as modeled for the first two dates of February.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.