Eomonth . . .

F

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
 
M

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
Click to expand...
 
Top