Use of EDATE function

  • Thread starter Thread starter The Hun
  • Start date Start date
T

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,
 
Look in Excel help for the EDATE function. It'll tell what to do if you get
#NAME? errors.
 
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
 
Back
Top