Guidance with employee shift schedule

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.