$1\mathrm{.}10$ On the Spring Remodel worksheet enter calculations to complete the table.

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 E$10$ 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 E$4)$ as the start date for the next remodel task.

Copy and paste down to cell D$10)$ to calculate the start dates for the remaining tasks.

In cell F$4),$ use the NETWORKDAYS function to calculate the number of days each task will take to complete.