weekdays calculation

[steve hill]

Hi
I have a sheet that list works order obtained by ms query. in columc C I have a sheduled start date, in column G I have the number of hours needed to produce the order. In column H I wanted to have the completion date based on an 8 hour working day, I used =C11+(G11/8) which is fine except it does not allow for weekends. Is there a way to calculate the completion date using week days only. Im using office 2007 but my work book needs to work in office 2003 as well.

Thanks
Steve

 

[JamesW]

Hi,

Try =Workday(start_date,number_of_days)

 

[steve hill]

Hi,

Try =Workday(start_date,number_of_days)

hi
not quite sure how to use this tried =WORKDAY(C11,G11) it added 98 days for a 70 hour order, can you give me more details on how to use the formula

thanks

steve

 

[GlennUK]

You forgot to divide G11 by 8.

 

[JamesW]

You forgot to divide G11 by 8.

Oops, didn't see you had hours. Glenn is correct.

 

[steve hill]

You forgot to divide G11 by 8.

thanks that did the trick

steve