2016-06-15T06:06:13.365000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/131e604073f89e6c1dd54be88b94b7befd881f2e 0 0 33007 12987 view1 2 7 0 0 0 0 2 0 0 0 0 0 100 60 true 1 9 0 0 0 0 2 0 0 0 0 0 100 60 true Sheet2 1241 0 100 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn cs CZ en US nl NL true true 3 1 true 1 true qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč $ - $ € - € - € / / / / . . ??? Page 1 ??? (???) 00.00.0000, 00:00:00 Page 1 / 99 NETWORKDAYS Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple NETWORKDAYS formulas with local references and values Function Expected Correct FunctionString Comment DATA 1 17 17 PRAVDA =NETWORKDAYS(K2;K3;K4:K6) 01.11.2014 0 0 0 PRAVDA =NETWORKDAYS(K2;K2;K2) 30.11.2014 0 20 20 PRAVDA =NETWORKDAYS(K2;K3;L2) 11.11.2014 0 20 20 PRAVDA =NETWORKDAYS(K2;K3;) 27.11.2014 0 -20 -20 PRAVDA =NETWORKDAYS(K3;K2;) 28.11.2014 0 17 17 PRAVDA =NETWORKDAYS(DATE(2014;11;1);DATE(2014;11;30);{"2014-11-11";"2014-11-28";"2014-11-27"}) Fixed withhttps://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=3c2803bdbc598deeaf6efe43870d4f9d61cb2c6a 24.12.2001 1 3 3 PRAVDA =NETWORKDAYS(K2;K2+6;;{1;0;1;0;1;0;1}) 25.12.2001 21 21 PRAVDA =NETWORKDAYS(K2;K3;;{0;0;0;0;0;1;1}) 26.12.2001 20 20 PRAVDA =NETWORKDAYS(K2;K3;;{1;0;0;0;0;0;1}) should be the same like row 5 tdf#100342 31.12.2001 20 20 PRAVDA =NETWORKDAYS(K2;K3;;M1:M7) 01.01.2002 17 17 PRAVDA =NETWORKDAYS(day1;day2;days) 17 01.12.2001 NETWORKDAYSSummary: Returns the whole number of work days between two dates.Syntax: NETWORKDAYS( DateParam Date1 ; DateParam Date2 [ ; [ DateSequence holidays ] [ ; LogicalSequence workdays ] ] )Returns: NumberConstraints: NoneSemantics: Returns the whole number of work days between two dates.Work days are defined as non-weekend, non-holiday days. By default, weekends are Saturdays and Sundays and there are no holidays.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 by passing in a list of numbers which define which days of the week are workdays (indicated by 0) or not (indicated by non-zero) in order Sunday, Monday,...,Saturday. So, the default definition of the work week excludes Saturday and Sunday and is: {1;0;0;0;0;0;1}. To define the work week as excluding Friday and Saturday, the third parameter would be: {0;0;0;0;0;1;1}. 4