Networkdays between columns
 

I have start dates listed in A1 through A1300 and corresponding completion
dates in J1 through J1300. I am having trouble doing the networkdays for the
whole column ( in K) without doing each cell individually. Can you help?

Networkdays between columns
 

Hi,

Put this in K1 and doubleclick the cell fill handle and the formula will
fill down as far as the last populated cell in column J
holidays is a named range containing your countries national holidays

=NETWORKDAYS(A1,J1,holidays)

Mike

"NV" wrote:

I have start dates listed in A1 through A1300 and corresponding completion
dates in J1 through J1300. I am having trouble doing the networkdays for the
whole column ( in K) without doing each cell individually. Can you help?

Networkdays between columns
 

If in K1 you have =NETWORKDAYS(A1,J1) then 3 alternative ways to copy down
column K:

Select K1, copy, select K2:K1300, paste
Select the bottom right-hand corner of K1 and you'll see the cursor turn to
a square fill-hangle. Grab than and drag down K2:K1300.
Double click in the fill-handle (see above), and it will copy as far down
column K as you've got entries in J. [This is usually the easiest option]
--
David Biddulph

"NV" wrote in message
...
I have start dates listed in A1 through A1300 and corresponding completion
dates in J1 through J1300. I am having trouble doing the networkdays for
the
whole column ( in K) without doing each cell individually. Can you help?