[Libreoffice-bugs] [Bug 142920] Workday function give bad results

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.
As explained on WORKDAY spreadsheet function help [1]:

> The result is a date number that can be formatted as a date.
>
> WORKDAY(StartDate; Days [; Holidays])
>
> Days is the number of workdays. Positive value for a result after the start
> date, negative value for a result before the start date.

So the second parameter is not a date, but a number of days; the result is not
a number of days, but a date. You expect the opposite, which is another
spreadsheet function: NETWORKDAYS [2] (DIATRABALHOTOTAL in Portuguese).

[1]
https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_workday.html?DbPAR=CALC
[2]
https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_networkdays.html?&DbPAR=CALC

-- 
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/20210617/56e0db13/attachment.htm>