When I try to use EDATE & EOMONTH I get an invalid name error (#NAME).

When I look at the formulae in the cells they have been changed to eDATE and
eoMONTH.

Can anyone explain why this is? It is happening in Excel 2000 & 2002.

Think both functions require the Analysis Toolpak (ATP)
be installed and activated in Excel

Check the "Analysis Toolpak" box
(via Tools Add-Ins)

Chip Pearson's page has details on the ATP at:
http://www.cpearson.com/excel/ATP.htm

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"IC" wrote in message
...
When I try to use EDATE & EOMONTH I get an invalid name error (#NAME).

When I look at the formulae in the cells they have been changed to eDATE
and
eoMONTH.

Can anyone explain why this is? It is happening in Excel 2000 & 2002.

If you look at HELP for either function, it will tell you what the problem is
and how to fix it.

On Fri, 21 Jan 2005 10:22:07 GMT, "IC" wrote:

When I try to use EDATE & EOMONTH I get an invalid name error (#NAME).

When I look at the formulae in the cells they have been changed to eDATE and
eoMONTH.

Can anyone explain why this is? It is happening in Excel 2000 & 2002.