fdo77985 Calc function NETWORKDAYS()

Winfried Donkers W.Donkers at dci-electronics.nl
Tue Apr 29 23:40:13 PDT 2014


Hi Miguel (adding the mailing list again)

Yes, you are right, I messed up my message. Actually, I think it makes implementing full ODF-compliance easier :-)

Winfried


-----Oorspronkelijk bericht-----
Van: mariosv at miguelangel.mobi [mailto:mariosv at miguelangel.mobi] 
Verzonden: dinsdag 29 april 2014 16:24
Aan: Winfried Donkers
Onderwerp: NETWORKDAYS()

Hi Winfried,

maybe I'm wrong but reading in ODF definition I think the third parameter it's the same as excel. It's a fourth parameter for ODF about what weekdays are the workdays.

"The optional 3rd parameter Holidays can be used to specify a list of dates to be treated as holidays. Note that this parameter can be omitted as an empty parameter (two consecutive ;; semicolons) to be able to pass the set of Workdays without Holidays.
The optional 4th parameter Workdays can be used to specify a different definition for the standard work week..."

Best regards.
Miguel Ángel.

_____________________________________
Sent from http://nabble.documentfoundation.org



More information about the LibreOffice mailing list