Datediff() function is not provided; Yearfrac() function is provided instead. This causes lot of portability problems. Kspread does not provide yearfrac(), but supports datediff(); MS Office also supports function datediff().
Yearfrac is a OpenFormula/ODF function and needs to be implemented if we want to follow the standard. The bug here is the missing Datedif function from Openformula: http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1018176_715980110
I'll start working on it; I would like to have the datedif function myself too...
Created attachment 61212 [details] patch sofar, not yet ready for submitting
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4e71be498903dee5bf719a73f4976bb5356335dd fdo#44456 added calc function DATEDIF as in ODF1.2
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=40c8170c5281cd7b19313a79f902ef9715351c9f changes to patch fdo#44456 added calc function DATEDIF
This is not finished yet and needs some further love.
Created attachment 61607 [details] test case document ODF .ods Note difference in H17, hence H37 is red FALSE. I believe this is an error of Excel.
Created attachment 61608 [details] same test case saved as .xls
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=121a39be3019baa840bb595acf0e648245a01b04 further changes to patch fdo#44456 added calc function DATEDIF
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=eb1770f05fde3777af7a62ec1c84ce8b088e3ec4 further changes to patch fdo#44456 added calc function DATEDIF
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=485792374600cd9919ab6edf201e8bd97d640261 added unit tests for DATEDIF fdo#44456
*** Bug 260998 has been marked as a duplicate of this bug. *** Seen from the domain http://volichat.com Page where seen: http://volichat.com/chat-with-strangers Marked for reference. Resolved as fixed @bugzilla.