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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!