Description: Workday function give bad results Steps to Reproduce: 26-07-2021 A4 13-08-2021 B4 1. create function =DIATRABALHO(A4;B4;"25-12-2021") 2. test result Actual Results: 26-07-2021 13-08-2021 106592 Expected Results: 26-07-2021 13-08-2021 15 Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: calc well
Created attachment 172990 [details] =DIATRABALHO(A4;B4;"25-12-2021")
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
(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.
(In reply to paulo g. from comment #3) > The names of the functions may not be the best choice. The standard (English) name follows established standard naming for the functions, and I suppose that localization team also followed relevant Excel localized function name [1], which is a reasonable choice: having a different name would only introduce confusion, and prevent from easy reuse of formulas shared on Internet. [1] https://support.microsoft.com/pt-br/office/diatrabalhototal-fun%C3%A7%C3%A3o-diatrabalhototal-48e717bf-a7a3-495f-969e-5005e3eb18e7