Workday function not working

[Cam]

Hello,

Why does it returns "#NAME?" when I use =WORKDAY function in Excel 2003?

My formula is =WORKDAY(D4,-B1,Holiday!A2:E109) where D4 is a date and B1 is
the number of days.

Any sugguestion, thank you.

 

[Mike H]

Hi,

Straight from E2003 help

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Tools - Addins and then do what help says
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Cam]

I did have ToolPak loaded from the add-in, but it didn't work.

 

[Mike H]

Hi,

As posted and with the ATP loaded your formula works fine so try this

Check again you have loaded the correct ATP. You want the Analysis Toolpak
and not the Analysis Toolpak VBA

Check the spelling of your formula and to be sure paste the one in from your
first post because we know that's correct.

lastly select the cell with the formula and tap F2 and then press enter
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Cam]

Hi Mike,

I did exactly what you suggested and it still didn't work.
I have both Analysis Toolpak & Analysis Toolpak VBA selected.

What else can I do? Thanks

 

[Mike H]

Hmmm,

I'm confused. email me the file to the address below with the obvious
changes to the address and I'll take a look

m.l.hughes at virginmedia.com
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Shaz]

Did you guys solve this problem? I'm having the same issue. The cell will show #Value until i manually F2+enter in the cell. Once that is done, I won't have to do it again, until i close and restart the spreadsheet.

My formula is =Workday(today(),-2). Pretty standard. I use it everywhere. I've removed and readded in analysis toolpak and toolpak vba. When readding the formula will recalculate.

It seems to me that excel is not aware of the add-in.