Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
=WORKDAY
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. |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
=WORKDAY
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. |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
=WORKDAY
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. |