Place your mouse on the right corner of E2 until you see a black + sign and double-click or drag your mouse down to paste the formula in the remaining cells in column E. If you started in different cells in your worksheet, you’ll need to adjust this formula accordingly. TIP: It’s best to have the Duration field calculate the appropriate duration of the task based on the start and end dates. Start Date and End Date = formatted as a date.Then, format the columns as the following: Create columns for Task Name, Start Date, End Date, and Duration, and fill those cells with information from your project.
0 kommentar(er)
