ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   networkdays (https://www.excelbanter.com/excel-discussion-misc-queries/183649-networkdays.html)

oldLearner57

networkdays
 
hi community

when i used the networkdays() in the laptop with the trial 2003 excel, it
returns a #Name ?
but
when i used the networkdays() in another laptop with a full registered 2003
excel, it did return to me an output value!

can community please assist me on this?....is it because of the trial
version that does not return a value for the networkdays or is it some where
in excel that I need to tune to?

same error output when i use the datedif(past dtd, current dtd,"y"), the
trial version return a #value

thanks community for the help render

:)



--
oldLearner57

Mike H

networkdays
 
Hi,

Excel help gives the answer

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Tools|Addins

Mike

"oldLearner57" wrote:

hi community

when i used the networkdays() in the laptop with the trial 2003 excel, it
returns a #Name ?
but
when i used the networkdays() in another laptop with a full registered 2003
excel, it did return to me an output value!

can community please assist me on this?....is it because of the trial
version that does not return a value for the networkdays or is it some where
in excel that I need to tune to?

same error output when i use the datedif(past dtd, current dtd,"y"), the
trial version return a #value

thanks community for the help render

:)



--
oldLearner57


oldLearner57

networkdays
 
hi "Mike H" - 10s got it

thanks community as well

:)
--
oldLearner57


"Mike H" wrote:

Hi,

Excel help gives the answer

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Tools|Addins

Mike

"oldLearner57" wrote:

hi community

when i used the networkdays() in the laptop with the trial 2003 excel, it
returns a #Name ?
but
when i used the networkdays() in another laptop with a full registered 2003
excel, it did return to me an output value!

can community please assist me on this?....is it because of the trial
version that does not return a value for the networkdays or is it some where
in excel that I need to tune to?

same error output when i use the datedif(past dtd, current dtd,"y"), the
trial version return a #value

thanks community for the help render

:)



--
oldLearner57



All times are GMT +1. The time now is 11:55 AM.

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