Function disappearing in spreadsheet

  • Thread starter Thread starter lsgKelly
  • Start date Start date
L

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
 
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
 
Back
Top