Including Saturdays in Calc WORKDAY function

I want the WORKDAY function in Calc to include saturdays as workday. Now the function excludes saturdays and Sundays. Thanks in advance for any help.

Thank you moggi, but the formula seems not working. My formula =WORKDAY(C6,D6, Holidays,{1;0;0;0;0;0;0}) gives an error Err:502. Please help. BTW, thank you for the open formula link.

Hi @saji, Did you find an answer to your question? If you’re getting an error in the WORKDAY formula, you might want to file a bug here. Thanks!

The Workday function has an optional 4th parameter that you can use to specify which days are workdays. I can’t guarantuee that this is actually implemented in LibO.

The following function should give you the wished result=WORKDAY(Today(); 2;;{1;0;0;0;0;0;0}) will only mark Sundays as weekends.

moggi, are sure about 4th parameter?. I think there is only a 3th parameter, for include a list of the dates for non working days.

Yes, I’m sure because I read the spec. However I would need to check the implementation to see if we really support all 4 parameters. According to OpenFormula the first two are required parameters and the other two are optional.

And to back it up with a reference to the spec: OASIS Open Document Format for Office Applications (OpenDocument) Version 1.2 - Part 2: Recalculated Formula (OpenFormula) Format

Hmm - specs are from 2011 - if this is already implemented, it’s almost a bug that there’s no hint in the documentation about that new parameter.

We don’t implement every part of OpenFormula. This will take some time until every part of the OpenFormula Spec as part of ODF 1.2 Is implemented. Actually OpenFormula does not require to implement all formulas mentionend there except the basic variant.

Sorry @mmohrhard - wasn’t meant as critizism. I just wanted to express that if such a feature would be already implemented, it should be expressed in the documentation. Of yourse it isn’t a bug that the fourth parameter isn’t implemented yet. sorry again for the confusion…

Hi @saji,

If you’re not able to specify Saturday as a workday per the WORKDAY function, please file an enhancement bug. Don’t forget to mark your bug as an ‘enhancement’. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

Thanks!

I would like to know if networkdays has similar tweak to use to calculate number of working days between start date and end date but consider Saturday to be working.

I tried using the array as 4th parameter in function NETWORKDAYS but got error.
Libre office 4.1.1.2

Thanks in advance,