Networkdays Question

[Los Coy]

Hi Guys, Brand new to the forums here but hopefully i will be using you a lot in the coming weeks and months.

I have a question about =networkdays.

I undestand that I can =networkdays cell a1 and cell b1 and get the time between the dates to show up in cell c1.

My question is that is it possible to do this on entire columns? For instance can i take all the dates in Column A and Column B and have the networkdays calculator run its magic and have them all appear in column C?
Or do i have to run the command on each individual column?

All help appreciated!

EDIT-Using Excel 2010

 

[T. Valko]

Hi Guys, Brand new to the forums here but hopefully i will be using you a lot in the coming weeks and months.

I have a question about =networkdays.

I undestand that I can =networkdays cell a1 and cell b1 and get the time between the dates to show up in cell c1.

My question is that is it possible to do this on entire columns? For instance can i take all the dates in Column A and Column B and have the networkdays calculator run its magic and have them all appear in column C?
Or do i have to run the command on each individual column?

All help appreciated!

EDIT-Using Excel 2010

In Excel versions thru Excel 2007, you'd have to use the formula on each individual column (whatever that means?).

In other words, the NETWORKDAYS function doesn't work on arrays.

I don't think this behavior would have changed in Excel 2010.