Every time I try to use EOMonth I get #Name?
 

I am building a spreadsheet that requires it to automatically generate the
last day of the month (for any month). I found the EOMonth function and every
time I use it all it returns is the "#NAME?" error message. I even tried hard
coding the function (=EOMonth("01/01/2006",0)), which should return
"01/31/2006" but just returns the error message "#NAME?".

Does anyone know how to get this to work?

EOMONTH is part of the Analysis Toolpak add-in, which you need to
activate by means of Tools|Add-Ins.

Othwerwise, invoke the equivalent:

=DATE(YEAR(A1),MONTH(A1)+1,0)

David wrote:
I am building a spreadsheet that requires it to automatically generate the
last day of the month (for any month). I found the EOMonth function and every
time I use it all it returns is the "#NAME?" error message. I even tried hard
coding the function (=EOMonth("01/01/2006",0)), which should return
"01/31/2006" but just returns the error message "#NAME?".

Does anyone know how to get this to work?

On Fri, 30 Sep 2005 15:01:02 -0700, "David"
wrote:

I am building a spreadsheet that requires it to automatically generate the
last day of the month (for any month). I found the EOMonth function and every
time I use it all it returns is the "#NAME?" error message. I even tried hard
coding the function (=EOMonth("01/01/2006",0)), which should return
"01/31/2006" but just returns the error message "#NAME?".

Does anyone know how to get this to work?

Copied from HELP for EOMONTH function:

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