<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Workday function give bad results" href="https://bugs.documentfoundation.org/show_bug.cgi?id=142920#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Workday function give bad results" href="https://bugs.documentfoundation.org/show_bug.cgi?id=142920">bug 142920</a> from <a class="email" href="mailto:paulo_fg@hotmail.com" title="paulo g. <paulo_fg@hotmail.com>"> paulo g.</a> <pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=142920#c2">comment #2</a>) > 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] > <a href="https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_workday">https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_workday</a>. > html?DbPAR=CALC > [2] > <a href="https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_networkdays">https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_networkdays</a>. > html?&DbPAR=CALC Thanks. The names of the functions may not be the best choice. I have to be more attention.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>