Use of EDATE function

[The Hun]

Using Excel 2002

I'm following the info in Help, but my results are always #NAME?. I
get the same result even when I copy/paste the demo into a worksheet.
Can anyone help?

Thanks,

 

[T. Valko]

Look in Excel help for the EDATE function. It'll tell what to do if you get
#NAME? errors.

 

[AdamV]

To use EDATE (and several other date related functions such as
NETWORKDAYS) you need to install and enable the Analysis ToolPak.
Have you done this?
If not, go to Tools > Addins > tick the checkbox for "Analysis ToolPak"
If there is no such item listed, you need to run the installation again,
do a custom install (over the top of your existing one) and include this
add-in.

Hope this helps