Eomonth . . .

[Fable]

Greetings,

EOMONTH is part of the Analysis toolpack, how can I make sure the en
user has it installed or would thier be a alternate formula that woul
avoid this problem.


Any help is appreciated

 

[Arvi Laanemets]

Hi

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


Arvi Laanemets

 

[Myrna Larson]

Of course that formula is for the end of the current month. The EOMONTH
function takes a 2nd argument -- the number of months. So the "+1" in your
formula has to be replaced by "number of months + 1"

Hi

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


Arvi Laanemets