referencing =networkdays??

[benjii19]

I have a sheet which exports from another program into Excel. The sheet layout stays pretty much the same and the two cell columns I need start AL12 and AG12.

I want to reference into a summary workbook, so that every time I export the figures from the other program all I have to do is update the reference to the new export.


Now I know how to reference a cell from another work book, but what I want is to apply a =NETWORKDAYS function into the summary book. which references the original exported workbook.

AL12 has 01/01/15

AG12 has 01/07/15

applying networkdays formula works great but how do i get that to work from the other summary book?

=NETWORKDAYS('[PWC.xls]7011788'!AG12,AL12) I tried this but it doesn't calculate properly, WORKBOOK is PWC SHEET is 7011788

[AlexandraT]

If both AL12 and AG12 are on the same sheet in the same workbook, amend your formula to include cell AL12 from that workbook:

=NETWORKDAYS('[PWC.xls]7011788'!AG12,'[PWC.xls]7011788'!AL12)

The formula you posted looks at AG12 from sheet 7011788 and at AL12 from the sheet with the formula in it (not sheet 7011788).

Does that solve the issue?

Alex

[benjii19]

Thank you so much!! worked

[benjii19]

=NETWORKDAYS('[PWC.xls]7011788'!AG24,'[PWC.xls]7011788'!AL24,'[HOLIDAY.xls]Sheet1!D2:D10)


OK I've just tried to add a holiday range from another sheet, something is wrong,.

[AlexandraT]

Missing an apostrophe after Sheet1. Try this

=NETWORKDAYS('[PWC.xls]7011788'!AG24,'[PWC.xls]7011788'!AL24,'[HOLIDAY.xls]Sheet1'!D2:D10)

Alex

[benjii19]

Once copied and pasted down the range D2:D10 from the holidays sheet changes. D3:D11,D4:D12 and so on. any ideas?

[benjii19]

sorted using $