$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 cel D$5,$ reference the date you siculated in cell E$4$ 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 F$4,$ use the NETWORKDAYS function to calculate the number of days each task will take to complete.

Reference the "Holiday