Spreadsheet Libre Version: 4.2.3.3 and 4.2.1.x versions 1. No option to change saturday to working day. 2. Need to use Formula NETWORKDAYS(START_DATE, END_DATE, HOLIDAYS) to include Saturday as working day. Any guidance/ help in achieving this would add to the functionality and flexibility in using LibreOffice. Thanks & Regards,
(In reply to comment #0) > Spreadsheet Libre Version: 4.2.3.3 and 4.2.1.x versions > > 1. No option to change saturday to working day. > > 2. Need to use Formula NETWORKDAYS(START_DATE, END_DATE, HOLIDAYS) to > include Saturday as working day. > > Any guidance/ help in achieving this would add to the functionality and > flexibility in using LibreOffice. > > Thanks & Regards, I confirm that NETWORKDAYS persently does not work as described in http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1018198_715980110 I will investigate cause and fix it. Note: function NETWORKDAYS.INTL has been implemented (see bug 79147) and will be available from version 4.3.0. This function offers full options to mark work/weekend days (i.e. every combination is possible).
The current NETWORKDAYS function in Calc is an implementation of Excel's Add-in function NETWORKDAYS, which has an argument fot holidays, but not for work/weekend-day definition. As this behaviour has been in Calc since the start, I have changed the version number in the header. It will be difficult to implement both Excel's NETWORKDAYS and OpenFormula NETWORKDAYS, but I may be able to do it.
I see no easy, fast way to implement this; setting the bug report back to new should others see a way to implement.
(In reply to comment #1) > Note: function NETWORKDAYS.INTL has been implemented (see bug 79147) Minor correction: bug 73147. Thanks for all your work on these functions Winfried.
Working on a solution.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=111952dccc1bf9e28e61c0233816248c848cbf53 fdo#77985 make calc function NETWORKDAYS comply with ODFF1.2 It will be available in 5.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.