We have a formula that randomly goes missing on one of our spreadsheets.
=EOMONTH(B13,(-1)) It will be working and then you go in and you have N/As
and you trace it back to the formula disappearing.

Any ideas?

Kelly

You might have some problems with the analysis toolpak which this function
belongs to, you can use this formula instead

=DATE(YEAR(B13),MONTH(B13),)



--


Regards,


Peo Sjoblom

"lsgKelly" wrote in message
...
We have a formula that randomly goes missing on one of our spreadsheets.
=EOMONTH(B13,(-1)) It will be working and then you go in and you have
N/A's
and you trace it back to the formula disappearing.

Any ideas?

Kelly