=WORKDAY

  • Thread starter Andrew Mackenzie
  • 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.
 
T

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.
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft 365 Activations, Users or Devices? 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Can't send emails on new PC 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
"Compile error in table level validation expression " after format 0
WORKDAY Function 3
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Autonumber field in Excel that behaves the same as Access 0

Top