Calculating weekdays

[Guest]

Further to my earlier post, one of the machines is using
Office 2002 (XP) it doesn't like the Networkdays
function, can anyone assist with a work around, please?


Mark

-----Original Message-----

 

[Ron Rosenfeld]

Further to my earlier post, one of the machines is using
Office 2002 (XP) it doesn't like the Networkdays
function, can anyone assist with a work around, please?


Mark

Mark,

What do you mean when you say "it doesn't like the ..." ?

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

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

If you mean something else, please be more specific.



--ron

 

[Mark]

Thanks, that's sorted it.


Mark

-----Original Message-----


Mark,

What do you mean when you say "it doesn't like the ..." ?

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

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

If you mean something else, please be more specific.



--ron
.