Function Missing

[Guest]

Hi,
I have previously used a "EOMONTH" formula/function and have seen it in use,
but although I have used this before and it is recommended on your site Excel
does not recognise this formula and it is not kept in the functions list.
Can you help?? can additional functions be added??

Mark

 

[David Biddulph]

Excel has a "Help" function, which is well worth using. If you look up
EOMONTH in help, it says:
"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

 

[Dave Peterson]

Tools|Addins|Check Analysis toolpak

If it doesn't appear in that list, you may need to install it--have your Office
CD available.

There are lots of functions in the analyis toolpak.

Check Peter Noneley's site for a nice reference:
http://www.xlfdic.com/