Formula Error

eddie57 · Apr 25th 2007

I am using this formula in an Excel worksheet. The formula is "=workday(K41,2)", which was giving me the date in field K41 plus 2 days. Now instead of the date I get "#NAME?". Anyone have an idea what went wrong?

Thanks
Eddie

Craig Ottley · Apr 25th 2007

Re: Formula Error

Looks like you've got a User Defined Function i may be wrong ByTheCringe over to you...

z

Anonymous · Apr 25th 2007

Re: Formula Error

Sounds as if you don't have the Analysis ToolPak installed. Use the Add-Ins command in Tools.

eddie57 · Apr 25th 2007

Re: Formula Error

Thanks. That worked. How do you think it got uninstalled?

Craig Ottley · Apr 25th 2007

Re: Formula Error

Got a quick question.

you know if i have the Analysis tool pack installed on my Comp. i take it the data would show correctly on another person's PC but if they recalculated the sheet it wouldn't work?

z

Anonymous · Apr 25th 2007

Re: Formula Error

Eddie, no idea, if you ever had it. As you say zimitry, these functions in the ToolPak appear to work until the sheet recalculates. So maybe you never had it.

Formula Error

Participate now!

Share