p45cal


The work sheet is called holidays. I am using the NETWORKDAY function so the
formula is =NETWORKDAYS(D10,C5,HOLIDAYS!D1:D23)


D10 is the start date, C5 is the due date minus any holidays that might
occur during that time gives me X# of days to complete. I actually have
gotten the formula to work but have to input the due date in backwards to
make it work. 2007/07/14.

Also I am trying to get the time required to process to change based on the
number of parts that we are processing. I have added the number of parts and
have put in the factor based on time to process ten parts but some times will
increase by 30 to 100% if the number of parts increase. Any easy way to
account for that?
Code Description Hour Code Factor Parts
10 IL MTL ISSUE 0.50 10 0.02 40
20 IL COAT 0.50 20 0.02 40
30 IL IMAGE 0.50 30 0.02 40
40 DES 0.50 40 0.02 40

Thanks again


Scott

"p45cal" wrote:

The first thing I'd do is change the name of the sheet holding the holidays.
Calling it NETWORKDAYS is the using the same name as the function which is
confusing, at least to anyone else looking at the code, if not to the
computer. Call it something else and reconstruct the formula from scratch. If
it still comes back with #VALUE then post again.
--
p45cal


"Scott W" wrote:

p45cal,

Your formula works great thanks again. Got one more question if you do not
mind. With this spreedsheet I am not only tracking how much time is required
to complete all of the steps and when they should be finished with one step
and on to the next, but I am also tracking when the process was started and
when the parts are due.

Customer
File # P11672
Due Date: 7/18/07
Released: 7/12/07 8:17 AM
Workdays: #VALUE!

My problem is I get an Value error.

In the released colum I am using =Now() and in the work days I am using
=NETWORKDAYS(C5,D10,NETWORKDAYS!C1:C10)
C5 is the due date, D10 is the first process step and NETWORKDAYS is another
work sheet that has all of the holidays.

Hope this enough information

Regards

Scott