Networkdays between columns

[NV]

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?

 

[Mike H]

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

 

[David Biddulph]

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]