ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Function Missing (https://www.excelbanter.com/excel-discussion-misc-queries/135905-function-missing.html)

Savillehead

Function Missing
 
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[_2_]

Function Missing
 
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."
--
David Biddulph

"Savillehead" wrote in message
...
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




Dave Peterson

Function Missing
 
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/

Savillehead wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com