project management find end date for task in Excel
Q55. I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?
For example, I have Start Date and Task duration for my project tasks. In Excel, how can I get End Date for tasks considering only working days?
To do it in Excel, here is the answer:
a) Enter the formula =WORKDAY(F4,E4) in End Date column for first task. Drag the formula all the way down to end of column.
The first argument in formula corresponds to Start Date and the second argument corresponds to task duration.
End dates are updated for all tasks as shown below.