why won't EDATE function work in Excel?

[Machead in a Microsoft World]

I can't seem to get this function to work. Even the example from the Office
website is returning a #NAME? error. Help?

[daddylonglegs]

EDATE function is part of Analysis ToolPak add-in, you get #NAME? error if it isn't installed.

To install

Tools > Addins > tick Analysis ToolPak box

[Machead in a Microsoft World]

Thanks much daddylonglegs! It's all good now.

"daddylonglegs" wrote:

>
> EDATE function is part of Analysis ToolPak add-in, you get #NAME? error
> if it isn't installed.
>
> To install
>
> Tools > Addins > tick Analysis ToolPak box
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=525074
>
>