WORKDAY function available?
in [General]
|
Prev: Allow selection of Validation List in a Protected Cell
Next: How do i do an eblast from an excel spreadsheet, that has email's
From: David Schwartz on 14 Apr 2010 16:32 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
From: "David Biddulph" groups [at] on 14 Apr 2010 16:38 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" <davids58(a)gmail.com> wrote in message news:f2982e7b-02e1-4399-9556-864c55e63656(a)w42g2000yqm.googlegroups.com... > 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
From: Lars-�ke Aspelin on 14 Apr 2010 16:44 On Wed, 14 Apr 2010 13:32:09 -0700 (PDT), David Schwartz <davids58(a)gmail.com> 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/excel/HP052093391033.aspx Hope this helps / Lars-�ke
From: David Schwartz on 14 Apr 2010 17:06 > 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.
From: David Schwartz on 14 Apr 2010 17:09
It seems I neglected to add the base date with the Date function. Seems to work now. Thanks! |