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

C

Cam

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
 
A

aamerrasheed via OfficeKB.com

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top