If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|