Workday function not working

  • Thread starter Thread starter Sabbath
  • Start date Start date
S

Sabbath

An associated created a spreadsheet and used the function "workday" in
some of the cells. The associate is using Excel 2002. I am using
Excel 2002 as well and when I open the workbook I get the #Name? in the
cell where the "workday" function is located. I went up to my
functions list and "workday" is not listed in my functions. How can I
fix this problem?

Thanks for all the help.
 
Sounds like you don't have the "add-in" installed on your machine. Go t
"tools" menu, then "add-ins", and in the dialogue box, make sur
"analysis toolpak" is checked. I'm pretty sure that is the add-in tha
contains the "workday" function. I had this same problem when I create
a report using the "networkday" function, then sent it to my boss, wh
did not have the add-in installed
 
Smunie, you were right. Made the change and tested it and it work
now.

Thanks for your help and speedy response.

God Bless.:
 
Back
Top