Day/Date problem

[vtisix]

Hi,

I use the formula =eomonth(A1,0) to return the date for the last day of
the month. The spreadsheet is an output of a database oriented
application. For some reason, I always get this error #NAME? for this
formula. Once in a while, it works out of the blue if I am doing some
work on the spreadsheet. I understand that the Analysis toolpak must be
added, and it is. Any clue?

Thanks,

vtisix

 

[Paulw2k]

Hi,

If you are getting "#NAME?" it means it that the Analysis toolpak has not
been loaded.
Make sure that the check box to the left of its name is ticked in the Add-in
list (Tools>Add-in) then click OK.

Regards

Paul

 

[Frank Kabel]

Hi
as posted in the other response this is probably due to a not installed
ATP. If you want a formual which does not rely on this Add-in try
=DATE(YEAR(A1),MONTH(A1)+1,0)