networkdays

[oldLearner57]

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

 

[Mike H]

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]

hi "Mike H" - 10s got it

thanks community as well