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?