EDATE &EOMONTH problem
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. |
All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com