=WORKDAY

  • Thread starter Thread starter Andrew Mackenzie
  • Start date Start date
A

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.
 
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.
 
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.
 
Back
Top