WORKDAY function available?

[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

 

[David Biddulph]

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

 

[Lars-Åke Aspelin]

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/excel/HP052093391033.aspx

Hope this helps / Lars-Åke

 

[David Schwartz]

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.

 

[David Schwartz]

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

Thanks!

 

[JLatham]

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.