whiteprose
New Member
- Joined
- May 15, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
- MacOS
In the Production Schedule worksheet, in the range A7:A14, enter formulas to calculate the percentage of each task that has been completed given the task’s start and stop dates and the current date in cell D5. (Hint: The percentage equals the number of days from the current date shown in cell D5 to the task’s start date in column C divided by the number of days allotted to complete each task.)
A B C D
A B C D
Bronco Design | |||
"Kinman Brothers Grocercy Store Website Task List" | |||
Today | 4/17/2017 | ||
Status | Task | Start Date | Stop Date |
Collect content | 4/3/2017 | 4/7/2017 | |
Menu interface and layout | 4/6/2017 | 4/21/2017 | |
First draft | 4/10/2017 | 4/18/2017 | |
Review and testing I | 4/16/2017 | 4/20/2017 | |
Second draft | 4/18/2017 | 4/27/2017 | |
Review and testing II | 4/26/2017 | 5/4/2017 | |
Final draft | 5/5/2017 | 5/10/2017 | |
Live Posting | 5/10/2017 | 5/15/2017 |