I believe that the message you get relates to Analysis ToolPak, I don't know how to solve that specifically, sorry.....but if all you want is the last day of last month you don't need EOMONTH.....just use

=A1-DAY(A1)

format as required, i.e. as a date of some sort