Data Loss 2007 (eomonth)

[daidipya]

I am using excel 2007 however teh file format that i save is 2003.
however frequently i get a data loss error whenever i open teh file .
I have fonud out that wherever i have used eomonth formaule the same
does not get opened and the data is lost. can anybody help me out.

 

[Rick Rothstein \(MVP - VB\)]

I don't know for sure, but the problem may have something to do with the
fact that EOMONTH is a built-in function in XL2007 and it requires the
Analysis Toolpak in XL2003. You can use this alternate formula in place of
EOMONTH and it should work in both versions of Excel...

=DATE(YEAR(<<D>>),MONTH(<<D>>)+1+<<M>>,0)

where <<D>> would be your date and <<M>> would be the number of months after
(plus value) or the number or months before <<D>>.

Rick

 

[Ron de Bruin]

Maybe this is your problem
http://www.rondebruin.nl/atp.htm