EOMONTH function not working

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.

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=266276

On 4 Oct 2004 15:57:34 -0700, (Michael) wrote:

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

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

ToolsAdd-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

On 4 Oct 2004 15:57:34 -0700, (Michael) wrote:

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.