EOMONTH function not working

[Michael]

My old computer had Windows 98.
My new computer has Windows 2000.
Both are using Office 2000.

=IF(B14="","",EOMONTH(A14,B14))

This formula on the old computer functions like this:
Where A14=1/4/2004 (Start Date) and B14=18 (Months in the future)
The product =July

But the new computer produces #NAME?
When I look in the Paste Function list, EOMONTH is not there.

=IF(A14="","",MONTH(A14+B14))
Produces January 10, 1900

What I really need, is for it to produce is:
July 2005

Any help is greatly appriciated.

Thanks
Mike.

 

[Cutter]

The EOMONTH() function is not available unless you install the Analysi
ToolPak add-in. You'll find it on your Office 2000 installation disc

 

[Ron Rosenfeld]

My old computer had Windows 98.
My new computer has Windows 2000.
Both are using Office 2000.

=IF(B14="","",EOMONTH(A14,B14))

This formula on the old computer functions like this:
Where A14=1/4/2004 (Start Date) and B14=18 (Months in the future)
The product =July

But the new computer produces #NAME?
When I look in the Paste Function list, EOMONTH is not there.

=IF(A14="","",MONTH(A14+B14))
Produces January 10, 1900

What I really need, is for it to produce is:
July 2005

Any help is greatly appriciated.

From HELP for EOMONTH:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron

 

[Gord Dibben]

EOMONTH is a Function from the Analysis ToolPak Add-in.

Tools>Add-ins. Checkmark Analysis ToolPak

If not listed in the Add-in options, you may have to do a re-install using the
"Typical" installation.

Gord Dibben Excel MVP