Help - return date-time from a given # of days
 

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

Help - return date-time from a given # of days
 

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