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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Dec 1 11:14:56 UTC 2020


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

--- Comment #8 from Uwe Auer <uwe at franke-auer.de> ---
The meaning of third argument may be clear from this example. From my point of
view it is about *full months* and a *counting diff of calendeder month months*
(in fact make information about day obsolete)

Date 1          Date 2          arg=0   arg=1
2010-12-12      2012-12-01      23      24
2010-12-12      2012-12-02      23      24
2010-12-12      2012-12-03      23      24
2010-12-12      2012-12-04      23      24
2010-12-12      2012-12-05      23      24
2010-12-12      2012-12-06      23      24
2010-12-12      2012-12-07      23      24
2010-12-12      2012-12-08      23      24
2010-12-12      2012-12-09      23      24
2010-12-12      2012-12-10      23      24
2010-12-12      2012-12-11      23      24
2010-12-12      2012-12-12      24      24
2010-12-12      2012-12-13      24      24
2010-12-12      2012-12-14      24      24
2010-12-12      2012-12-15      24      24
2010-12-12      2012-12-16      24      24
2010-12-12      2012-12-17      24      24
2010-12-12      2012-12-18      24      24
2010-12-12      2012-12-19      24      24
2010-12-12      2012-12-20      24      24
2010-12-12      2012-12-21      24      24
2010-12-12      2012-12-22      24      24
2010-12-12      2012-12-23      24      24
2010-12-12      2012-12-24      24      24
2010-12-12      2012-12-25      24      24
2010-12-12      2012-12-26      24      24
2010-12-12      2012-12-27      24      24
2010-12-12      2012-12-28      24      24
2010-12-12      2012-12-29      24      24

-- 
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/eb4136f2/attachment.htm>


More information about the Libreoffice-bugs mailing list