|  

» 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))


Rate This Tip
12 34 5
Rating: 2.71     Views: 19164
Project End with/without overtime.
RaginCajun
I was trying to figure out how you could caluculate a project end date, based on a start date (mm,dd,yyyy) and a project duration of lets say 6 hours, in an 18 hour work day and the work week is four days long (monday thru Thursday). I also would like to repeat the same calculation to include Friday thru Sunday only and again for the whole week monday thru Monday.

Cheers!
Dee Jackson
I would like to know how to project an end date. I want to write in a start date 02/24/2006 and want excel to put in the date after 180 days. For example after 180 days of 02/24/06 would be 08/22/06.
Click here to post comment
For Registered Users
Name
Comment Title
Comments