https://bugs.documentfoundation.org/show_bug.cgi?id=142920
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from Mike Kaganski <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
