ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Networkdays function problem (https://www.excelbanter.com/excel-discussion-misc-queries/171265-using-networkdays-function-problem.html)

Bright

Using Networkdays function problem
 
Hi all,

When I use the networkdays and workday functions in Excel2003, the library
path is displayed in the front of the function name.

For example:
= 'C:\Program Files\Microsoft Office
Project\OFFICE11\LIBRARY\ANALYSIS\ATPVBACS.XLA'!NE TWORKDAYS(D1,D2)

But it also work in this way without the library path in another machine.
= NETWORKDAYS(D1,D2)

How can I make it work without the library path?

Thanks in advance,





All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com