Question: Complete the table on the ProjectDates worksheet to calculate the start dates for the various phases of the project. Refer to the Federal Holidays table

Complete the table on the ProjectDates worksheet to calculate the start dates for the various phases of the project. Refer to the Federal Holidays table when needed to determine when there are work holidays. 6.1 Calculate the start date for the project. a. Place your calculation in cell (H5). b. The start date for the project is the start date in cell G2) unless the start date falls on a weekend (Saturday or Sunday) in which case if will be the next workday. 6.2) Calculate the start date for the remaining activities. a. Place your calculation for the "Approve Project Proposal" activity in cell (H6). b. The start date for each project activity depends on the start date and duration of the previous project activity. c. Ensure that the start date for the activity is a workday. d. Account for any holiday that might fall during the project. e. Reuse your formula to calculate the start date for the remaining project activities
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
