why won't EDATE function work in Excel?

[Guest]

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? erro
if it isn't installed.

To install

Tools > Addins > tick Analysis ToolPak bo

 

[Guest]

Thanks much daddylonglegs! It's all good now.