[Andrew Mackenzie]

I have a formula that has worked fine on my pc:

=workday(F9,30)

However, I moved the file to another pc on the network and I now get a
result #NAME?

Both PCs are using Excel 2000.

Can anyone shed any light?

Andrew.

[Tony Jollans]

This is a Word newsgroup. Questions about Excel are best asked in an Excel
newsgroup. However ...

WORKDAY is a Function in the Analysis ToolPak AddIn so I presume you do not
have t hat Added-In on the one PC. Go to Tools AddIns... and check the
box.

--
Enjoy,
Tony

"Andrew Mackenzie" wrote in message
...
I have a formula that has worked fine on my pc:

=workday(F9,30)

However, I moved the file to another pc on the network and I now get a
result #NAME?

Both PCs are using Excel 2000.

Can anyone shed any light?

Andrew.

[Andrew Mackenzie]

Thanks and apologies for posting to the wrong group (I have both open
simultaeously and sometimes get a bit trigger happy with the "send" button.

Andrew.


"Tony Jollans" My forename at my surname dot com wrote in message
...
This is a Word newsgroup. Questions about Excel are best asked in an Excel
newsgroup. However ...

WORKDAY is a Function in the Analysis ToolPak AddIn so I presume you do
not
have t hat Added-In on the one PC. Go to Tools AddIns... and check the
box.

--
Enjoy,
Tony

"Andrew Mackenzie" wrote in message
...
I have a formula that has worked fine on my pc:

=workday(F9,30)

However, I moved the file to another pc on the network and I now get a
result #NAME?

Both PCs are using Excel 2000.

Can anyone shed any light?

Andrew.