[Libreoffice-bugs] [Bug 138313] MONTHS() function gives the wrong result

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138313

Justin L <jluth at mail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Hardware|x86-64 (AMD64)              |All
            Summary|MONTHS() function gives     |MONTHS() function gives the
                   |different results than      |wrong result
                   |Excel                       |

--- Comment #2 from Justin L <jluth at mail.com> ---
Excel 2016 doesn't have the function "months", and I don't see any reference to
it on the Internet. It looks like a LO only function.

I certainly would not expect 12 months as a response to "how many months are
between Dec 2010 and Dec 2012". On the other hand, I can't imagine what that
third value could refer to except perhaps inclusive/exclusive of the days -  to
perhaps swing the value to 23 or 25 in the case of "interval".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201201/ed0db370/attachment.htm>