Apache OpenOffice (AOO) Bugzilla – Issue 1714
edate function
Last modified: 2001-12-04 13:08:26 UTC
edate function does not work for a change of year, the example is edate(last cell;1) stops working at change of year. Workaround is to use DATE function (Date(year(last cell+45);month(last cell +45);1)-1
It's not the formula editor it's the spreadsheet.
It's the getEdate function from the analysis add-in.
The EDATE function works correctly now up to year 32767. Fixed in SRC641G
Fixed and verified in OO641
.