Ask Your Question
0

Including Saturdays in Calc WORKDAY function [closed]

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

saji gravatar image

updated 2015-11-02 04:50:31 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 04:50:43.201087

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 gravatar imagesaji ( 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 gravatar imagequbit ( 2013-01-25 23:57:23 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2013-02-22 20:18:52 +0200

qubit gravatar image

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!

edit flag offensive delete link more
1

answered 2012-09-03 00:02:47 +0200

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.

edit flag offensive delete link more

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.

m.a.riosv gravatar imagem.a.riosv ( 2012-09-03 02:17:59 +0200 )edit
1

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 gravatar imagemoggi ( 2012-09-03 02:29:43 +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 gravatar imagetohuwawohu ( 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 gravatar imagemoggi ( 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 gravatar imagetohuwawohu ( 2012-09-03 20:02:30 +0200 )edit
0

answered 2014-04-26 14:32:09 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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,

edit flag offensive delete link more

Question Tools

Stats

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

Seen: 1,863 times

Last updated: Apr 26 '14