Having difficulties with Networkdays formula in my macro

I have a column that I need to add a networkdays formula to. I started to create some code that I thought would work.

Please Login or Register  to view this content.

However, I get a syntax error with the formula. What is the best way to resolve this?



Thanks!!

I would manually enter

=Networkdays(K2,L3)

I keyed the wrong formula...it should be...

=networkdays(K2,L2)

And I would have this in N2. I used to the auto fill this down the column. However, I would like to create a code to accomplish the same thing.

This works great!!! How do I incorporate holidays into this formula?

I would put the holiday(s) is a blank cell and then add to the formula.

Ex.
Put 7/4/2012 is B22
=Networkdays(K2,L2,$B$22)

Then if I had multiple days...

B22 to B25
=Networkdays=(K2,L2,$B$22:$B$25)

---------- Post added at 12:25 PM ---------- Previous post was at 12:25 PM ----------

But is there a way to use your previous formula but then add the actual date(s)?

I have uploaded a sample worksheet of the data I am working with. As you can see the first record actual went to the vendor for repair(O2), came back from the vendor(P2), then went back to vendor(Q2), and then came back from the vendor(R2) and in T2 I used the following formula to calculate the Net work days.

=Networkdays(O2,R2)

Then the second record only went to the vendor once for repair, so the formula I used in T3 is...

=Networkdays(O3,P3)

How can I write a code that addresses these types of variables?

I have another question...If the device goes to the vendor and returned then I have been subtracting 2 for the number of days in transit. Then if the the device goes to vendor, then returned, then is a repeat to vendor and repeat return from vendor, I subtract 4 for the number of days in transit...how can I modify this code for those conditions?

---------- Post added at 04:13 PM ---------- Previous post was at 04:10 PM ----------

The repeat repairs worksheet I posted previously is an example of what I am talking about...

Previously, I would have manually entered this formula in the Moto TAT column for the first record...

=Networkdays(O2,R2)-4

Then I would enter this formula in the Moto TAT column for the second record...

=Networkdays(O2,P2)-2