ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   eomonth (https://www.excelbanter.com/excel-worksheet-functions/134947-eomonth.html)

John T[_2_]

eomonth
 
eomonth formula returns #NAME? despite Analysis Tools Pak having been added

Gary Brown

eomonth
 
There are 2 Analysis Pak add-ins. One is 'Analysis ToolPak' and the other is
'Analysis ToolPak - VBA'. Did you check both of them?
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"John T" wrote:

eomonth formula returns #NAME? despite Analysis Tools Pak having been added


John T[_3_]

eomonth
 
Thanks Garry. Wierd one this. eomonth previously performed OK on my computer
but today failed to work. I restarted the computer and reloaded to Analysis
Tool pak and the eomonth formula returned the correct result. One of those
computer gliches

John T

"Gary Brown" wrote:

There are 2 Analysis Pak add-ins. One is 'Analysis ToolPak' and the other is
'Analysis ToolPak - VBA'. Did you check both of them?
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"John T" wrote:

eomonth formula returns #NAME? despite Analysis Tools Pak having been added


Gary Brown

eomonth
 
Glad you're all set.
--
Gary Brown

"John T" wrote:

Thanks Garry. Wierd one this. eomonth previously performed OK on my computer
but today failed to work. I restarted the computer and reloaded to Analysis
Tool pak and the eomonth formula returned the correct result. One of those
computer gliches

John T

"Gary Brown" wrote:

There are 2 Analysis Pak add-ins. One is 'Analysis ToolPak' and the other is
'Analysis ToolPak - VBA'. Did you check both of them?
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"John T" wrote:

eomonth formula returns #NAME? despite Analysis Tools Pak having been added



All times are GMT +1. The time now is 05:14 AM.

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