Data Loss 2007 (eomonth)

  • Thread starter Thread starter daidipya
  • Start date Start date
D

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