![]() |
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 |
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 |
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