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

Have you done what it says in the sentence starting "If this function is not
available, and returns the #NAME? error,..." ?
--
David Biddulph


"David Schwartz" wrote in message
...
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

On Wed, 14 Apr 2010 13:32:09 -0700 (PDT), David Schwartz
wrote:

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


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/ex...093391033.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

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.

"David Schwartz" wrote:

It seems I neglected to add the base date with the Date function.
Seems to work now.

Thanks!
.