Need help to make employee roster sheet

Good day,

Please help me to make this report sheet
details explained in the attached sheet.

How do we know what Sequence - Incharge Employees belong to which dates?

To show all of the dates of the month in A1 in column A, try this:

A4 =A1+0
A5 =IFERROR(IF(MONTH(A4+1)<>MONTH(A4),"",A4+1),"")

Drag the formula in A5 through A34 then format A5:A34 as Custom: d to display only the day number.

I believe that I understand what you are looking for now.

You want the employees that are listed in column C of the 'info' sheet to repeat in column B of the 'Roster' sheet for all of the dates that are not holidays (which are listed in column E of the 'info' sheet).

More than that, you don't want to start at the beginning of the Sequence list (column C of 'info') at the beginning of every month, which explains why Feb 1st should be TM (Jan 31st is BC).

This became a lot more complicated than I had originally imagined. I'll take a look at it and see if I can come up with something.

Start by following the instructions in post #3.

Next, you want to set up your 'info' sheet. I made the holidays into a table so that all you have to do is put any additional holidays (full date) at the bottom.

Now, write out all possible dates in 2017 in column H.

Column J shows whether or not the corresponding date in column H is a holiday (1=TRUE, 0=FALSE).
J4 =COUNTIF(Table1[Holidays - Date],H4)

Column I shows the correct employee for each date in column H.
I4 =IF(J4,"-",INDEX(C$4:C$10,MOD(COUNTIF(J$4:J4,0)-1,7)+1))

Now, in B4 of the 'Roster' sheet:
=IFERROR(INDEX(info!I$4:I$368,MATCH(A4,info!H$4:H$368,0)),"")

The only thing that you have to do to this workbook is add in all of the holidays in column E of the 'info' sheet.
Then, you can change A1 of the 'Roster' sheet to any of the months and the dates and employees will show automatically.

See attachment for clarification.