» Calculating a Project's End Date

CATEGORY - Excel Date & Time Formulas VERSION - All Microsoft Excel Versions

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

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 2.71 Views: 18887

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.

» Calculating a Project's End Date

Book Store:

Recommended Books:

For Registered Users

For Guest