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.