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
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
Re: Formula Error
Looks like you've got a User Defined Function i may be wrong ByTheCringe over to you...
z
Re: Formula Error
Sounds as if you don't have the Analysis ToolPak installed. Use the Add-Ins command in Tools.
Re: Formula Error
Thanks. That worked. How do you think it got uninstalled?
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
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.
Don’t have an account yet? Register yourself now and be a part of our community!