GSOD 2020 - Possible Error in Help pages

For this issue:

WORKDAY.INTL seems linked to WORKDAY of ODF based on the parameters but
Weekend accepts 1 to 17 or 0000011 type of string.

So both functions are somehow similar to ODF function WORKDAY. So which one
to link?

The function WORKDAY in help pages and also its implementation has only
the first 3 parameters whereas ODF section has 4 parameters. Also ODF
mentions passing {0;0;0;0;0;1;1} or {1;0;0;0;0;0;1} or even this
{0;0;0;1;1;1;1} as the Holiday parameter which when I tried does not
change the result.

I have stated that "Calc's implementation of WORKDAY function is not
strictly in accordance with ODF 1.2." in wiki.

Calc's function works just like MS Excel's function does.

Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430

Regards,
Ronnie

Hi Ronnie,

Please link both pages to the ODF's WORKDAY function but explain that:

(1) Calc's WORKDAY function does not support the optional Workdays argument that is specified in the ODF. Also, with regards to the issues you raise concerning the example definitions of the work week, please would you note them on the Discussion page for now and I'll look into them when I review the page.

(2) Calc's WORKDAY.INTL function swaps the order of the optional Holidays and Workdays arguments that are specified in the ODF; it also extends the definition of the Workdays argument compared to the ODF. Calc's WORKDAY.INTL function is consistent with Excel's function of the same name for improved inter-operability.

Regards,

Steve

Sure Steve thanks. Will do that now.

Regards,