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.
Place your calculation in cell E5.
The start date for the project is the start date in cell D2 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.
Place your calculation for the "Approve Project Proposal" activity in cell E6.
The start date for each project activity depends on the start date and duration of the previous project activity.
Ensure that the start date for the activity is a workday.
Account for any holiday that might fall during the project.
Reuse your formula to calculate the start date for the remaining project activities.
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 jroject. a. Place your calculation in cell ESL b. The start date for the project is the start dare in cell D2J unless the start date falls on a weekend (Saturday or Sunday) in which case if will be the next workday- Calculate the start date for the -emaining activities. a. Place your calculation for the "Approve Project Proposal" activity in cell E6J. 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
