Project management find end date for task in Excel

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?

excel project management find end date for task

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.

excel project management find end date for task


You can find similar Excel Questions and Answer hereunder

1) Sumifs with date range as criteria in Excel

2) I have a very complex macro that runs for a long time - is there any way I can set up an audible alarm indicating macro run is over?

3) How can I have text autocomplete by typing in a short code for the text?

4) How can I find the least common multiple using Excel?

5) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

6) I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?

7) How can I clear cell after activating a routine when there is a change in value of a cell?

8) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

9) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

10) Given a raw data Table, how can I find the value of a field for a specific value of another field?


Here the previous and next chapter