EOMONTH function

[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

 

[Tim Otero]

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

 

[Ron Rosenfeld]

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

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