In cell E$4,$ use the WORKDAY function to calculate the end date for the Demolition task.

Reference the "Holiday Schedule" in your function.

Copy and paste down to to calculate the end date for the other tasks.

Note the calculation will show dates for $1900$ until you complete the next calculation.

In cell D$5,$ reference the date you calculated in cell as the start date for the next remodel task.

Copy and$-$paste down to cell to calculate the start dates for the remaining tasks.

In cell l$,$ use the NETWORKDAYS function to