Function disappearing in spreadsheet
 

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

Function disappearing in spreadsheet
 

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