Including Saturdays in Calc WORKDAY function

asked 2012-09-01 05:45:12 +0200

saji
11 ● 1

updated 2013-01-30 20:56:59 +0200

qubit

5693 ● 3 ● 48 ● 41

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.

delete close flag offensive retag edit

Comments

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.

saji ( 2012-09-15 02:38:54 +0200 )edit

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!

qubit ( 2013-01-25 23:57:23 +0200 )edit

Comments

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.

mariosv ( 2012-09-03 02:17:59 +0200 )edit

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.

moggi ( 2012-09-03 02:29:43 +0200 )edit

And to back it up with a reference to the spec: http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1018214_715980110

moggi ( 2012-09-03 02:31:06 +0200 )edit

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.

tohuwawohu ( 2012-09-03 06:55:22 +0200 )edit

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.

moggi ( 2012-09-03 19:36:39 +0200 )edit

Sorry @moggi - 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...

tohuwawohu ( 2012-09-03 20:02:30 +0200 )edit

Including Saturdays in Calc WORKDAY function

Comments

2 Answers

Comments

Resources

Donate

Question tools

Stats

Related questions