$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 Schedute" 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.

Reference the "Holiday Schedule" in your function.

Copy and paste the function down to cell F$10$ to calculate the number of days for the