EOMONTH function

  • Thread starter Thread starter daver676
  • Start date Start date
D

daver676

I have a large workbook that uses, among others, the
EOMONTH function. After installing the analysis toolpak
into Excel 2002, the function worked fine. But when
installed onto other computers on the network also running
Excel 2002, the function does not work. It only returns
#NAME. Any ideas on what the problem is? Thanks
 
All computers you wish to run your workbook must have the Analysis Toolpak
installed.

tim

| I have a large workbook that uses, among others, the
| EOMONTH function. After installing the analysis toolpak
| into Excel 2002, the function worked fine. But when
| installed onto other computers on the network also running
| Excel 2002, the function does not work. It only returns
| #NAME. Any ideas on what the problem is? Thanks
 
I have a large workbook that uses, among others, the
EOMONTH function. After installing the analysis toolpak
into Excel 2002, the function worked fine. But when
installed onto other computers on the network also running
Excel 2002, the function does not work. It only returns
#NAME. Any ideas on what the problem is? Thanks
Click to expand...

The other computers do not have the analysis toolpak installed, and it is
required in order for them to use the EOMONTH function.


You can either install the Analysis Toolpak on the other computers, or use an
equivalent function which does not require the analysis toolpak such as:


=DATE(YEAR(StartDate),MONTH(Start_Date)+Months+1,0)



--ron
 
Back
Top