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?

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 excel project management find end date for task


You can find similar Excel Questions and Answer hereunder

1) How can I identify all cells with Conditional Formatting in my WorkSheet?

2) Formula converts date to quarter and year in Excel

3) 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?

4) How to do date and time zone conversion in excel in Excel

5) 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?

6) How can I add interval to dates?

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

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

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

10) Find and count instances of a character in a string in Excel

11) Sumifs with date range as criteria in Excel

12) How can I identify all cells with Data Validation in my WorkSheet?

13) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?

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

15) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?