Networkdays between columns

  • Thread starter Thread starter NV
  • Start date Start date
N

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?
 
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
 
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]
 
Back
Top