Hello,

I am trying to find a formula to calculation the estimated completion date
for different operations which returns the date excluding holiday working 7
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
30 0.667
40 1.611
50 0.667

Thank for sugguestions