Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Use of EDATE function
1 view
Skip to first unread message
The Hun
Nov 23, 2009, 11:42:33 PM11/23/09
to
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
Nov 24, 2009, 12:11:58 AM11/24/09
to
Look in Excel help for the EDATE function. It'll tell what to do if you get
#NAME? errors.
#NAME? errors.
--
Biff
Microsoft Excel MVP
"The Hun" <e...@LAocean.com> wrote in message
news:344195d2-c472-4c9b...@z3g2000prd.googlegroups.com...
AdamV
Nov 25, 2009, 4:21:35 AM11/25/09
to
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.
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
0 new messages