Spreadsheet Libre Version: 22.214.171.124 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: 126.96.36.199 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
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":
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:
Affected users are encouraged to test the fix and report feedback.