yyducator Add-in 44251 (5) Project Dates Complete the table on the Next20WorkDays worksheet to calculate the start dates for the various phases of the project. Refer to "The 10 Federal Holidays in 2021" table when needed to determine when there are work holidays. (5.1) Calculate the start date for the project. a. Place your calcolation in cell (05). b. The startdate for the project is the start date in cell (D2) uniess the start dote fallis on a weekend (Saturday or Sunday) in which case if will be the next workday. (5.2) Calculate the start dates for the remaining phases of the project. a. Place your calculation for Project Phase 2 in cell (D6). b. Use the WORKDAY function. c. References the start date and days of work values for the previous project phase in your calculation. d. Account for any holidays that might fall during the project. e. Reuse your formula to calculate the start date for the remhing project phases. (5.3) Calculate the day of the week for each of the project phase start dates. a. Place your calculation for the first project phase in cell E5. b. Use the CHOOSE function. c. In the same formula, use the WEEKDAY function to calculate the day of the week for the project phase 1 start date as the first. argument of the CHOOSE function. d. Use "Sun". Mon: Tuet, "Wed". Thur':rir, and "Sat" as the rames of the days. e. Reuse your formula to calculate the day of the week for the remaining project plose start dates. Start Date 12/28/20 The 10 Federal Holidays in 2021 \begin{tabular}{|c|l|} \hline 1/1/21 & New Year's Day \\ 1/18/21 & Martin Luther King Jr. Day \\ 2/15/21 & President's Day \\ 5/31/21 & Memorial Day \\ 7/4/21 & Independence Day \\ 9/6/21 & Labor Day \\ \hline 10/11/21 & Columbus Day \\ \hline 11/11/21 & Veterans Day \\ \hline 11/25/21 & Thanksgiving Day \\ 12/25/21 & Christmas Day \\ \hline \end{tabular}