Tip Printed from ExcelTip.com

---

Calculating a Project's End Date


Problem:

Columns A & B contain the start date of various projects and the number of hours required for each project's completion.
We want to calculate each project's end date, based on the number of required hours, a specified number of daily working hours (cell C2), and the assumption that work is only done on weekdays.

Solution:

Use the WORKDAY and ROUNDUP functions as shown in the following formula:
=WORKDAY(A2,ROUNDUP(B2/$C$2,0))