https://bugs.documentfoundation.org/show_bug.cgi?id=142920
--- Comment #3 from paulo g. <[email protected]> ---
(In reply to Mike Kaganski from comment #2)
> 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
Thanks. The names of the functions may not be the best choice. I have to be
more attention.
--
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
