Hello,

I am trying to find a formula to calculation the estimated completion date
for different operations which returns the date excluding holiday working 5
days a week @ 19 hours per day, but couldn't seemed to find the answer how.

Column A1 is the startdate.
Column B is the production time in days required to completed.
Column C starting C3 is the calculated value of completion date in date time
format.

Here is the sample table:
A B C
1/2/2009 6:00 AM StartDate
Opr ProdTime (#Days) ComplDate
10 2.045 1/6/09 1:04 AM
20 0.143 1/6/09 3:15 AM
30 0.667 "
40 1.611 "
50 0.667

Thank for sugguestions

Hi,
You can use the excel function "WORKDAY".
if you put all holidays in one column from cell D2 to D50, you can put this
formula on Column C.

=WORKDAY(A2,B2,D2:D50)
A2 is the start date, B2 is number of days and D2:D50 are dates for holidays.
You'll get the end date!

Thanks

Cam wrote:
Hello,

I am trying to find a formula to calculation the estimated completion date
for different operations which returns the date excluding holiday working 5
days a week @ 19 hours per day, but couldn't seemed to find the answer how.

Column A1 is the startdate.
Column B is the production time in days required to completed.
Column C starting C3 is the calculated value of completion date in date time
format.

Here is the sample table:
A B C
1/2/2009 6:00 AM StartDate
Opr ProdTime (#Days) ComplDate
10 2.045 1/6/09 1:04 AM
20 0.143 1/6/09 3:15 AM
30 0.667 "
40 1.611 "
50 0.667

Thank for sugguestions

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200901/1