WORKDAY function available?

  • Thread starter Thread starter David Schwartz
  • Start date Start date
D

David Schwartz

I'm using Excel 2003 SP3. I have a need to use the WORKDAY function.
Microsoft suggests it's available to me in my Excel version (http://
office.microsoft.com/en-us/excel/HP052093391033.aspx). However, when I
try to use it I get a #NAME? error and I can't seem to find any
reference to such a function in the app.

=workday(A2,E2) << this is the syntax I'm using

Is this function truly available in my Excel version? If so, what's
with this error?

TIA,
David
 
I'm using Excel 2003 SP3. I have a need to use the WORKDAY function.
Microsoft suggests it's available to me in my Excel version (http://
office.microsoft.com/en-us/excel/HP052093391033.aspx). However, when I
try to use it I get a #NAME? error and I can't seem to find any
reference to such a function in the app.

=workday(A2,E2) << this is the syntax I'm using

Is this function truly available in my Excel version? If so, what's
with this error?

TIA,
David
Click to expand...


You may have to install and load the Analysis Toolpak add-in.
See here for how to do this
http://office.microsoft.com/en-us/excel/HP052093391033.aspx

Hope this helps / Lars-Åke
 
You may have to install and load the Analysis Toolpak add-in.
See here for how to do thishttp://office.microsoft.com/en-us/excel/HP052093391033.aspx
Click to expand...

Well, the interesting thing is that my 'Add-Ins' dialog shows that the
Analysis ToolPak is already installed.
 
It seems I neglected to add the base date with the Date function.
Seems to work now.

Thanks!
 
Thanks for letting everyone know what the source of the problem was. It
always helps others down the road to see that kind of thing.
 
Back
Top