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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Function & EDATE 3
EDATE Function 4
EDATE Function disappears intermittently 1
Edate function 1
EDATE returns #NA Error when Excel opened again 6
edate missing 4
edate missing - still stumped 3
EDATE 2

Back
Top