Function disappearing in spreadsheet

[lsgKelly]

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

 

[Peo Sjoblom]

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