2016-06-16T17:41:16.399000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/f9f090d0d0f2b454d6c1dd14fe735e7e83fda9da 0 0 22009 4261 view1 1 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 12 26 0 0 0 0 2 0 0 0 0 0 100 60 true false Sheet2 1241 0 100 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 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č € - € - € / / / / € € - : : : : WAAR WAAR ONWAAR - - - - / / € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - / / / / - - - - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 WORKDAY.INTL Function Result TRUE Sheet Result Description 1 TRUE Simple WORKDAY.INTL formulas with local references and values Function Expected Correct FunctionString Comment DATA 1 41950 41950 TRUE =WORKDAY.INTL(K2,K3,,K4:K6) 11/01/2014 0 41950 41950 TRUE =WORKDAY.INTL(K2,K3,1,K2) 5 0 #VALUE! error TRUE =WORKDAY.INTL(K2,K3,L2) 11/11/2014 0 41950 41950 TRUE =WORKDAY.INTL(K2,K3,) 11/27/2014 0 41951 41951 TRUE =WORKDAY.INTL(DATE(2014,11,1),2,5,{"2014-11-2";"2014-11-3";"2014-11-4"}) 11/28/2014 0 41951 41951 TRUE =WORKDAY.INTL($K$2,$K$3,2,$K$2) 12/24/2001 1 41951 41951 TRUE =WORKDAY.INTL($K$2,$K$3,3,$K$2) 12/25/2001 41951 41951 TRUE =WORKDAY.INTL($K$2,$K$3,4,$K$2) 12/26/2001 41951 41951 TRUE =WORKDAY.INTL($K$2,$K$3,5,$K$2) 12/31/2001 41951 41951 TRUE =WORKDAY.INTL($K$2,$K$3,6,$K$2) 01/01/2002 41949 41949 TRUE =WORKDAY.INTL($K$2,$K$3,7,$K$2) 17 Err:502 error TRUE =WORKDAY.INTL($K$2,$K$3,8,$K$2) 12/01/2001 11/07/14 41950 TRUE =WORKDAY.INTL($K$2,$K$3,11,$K$2) -5 11/07/14 41950 TRUE =WORKDAY.INTL($K$2,$K$3,12,$K$2) 11/07/14 41950 TRUE =WORKDAY.INTL($K$2,$K$3,13,$K$2) 11/07/14 41950 TRUE =WORKDAY.INTL($K$2,$K$3,14,$K$2) 11/07/14 41950 TRUE =WORKDAY.INTL($K$2,$K$3,15,$K$2) 11/06/14 41949 TRUE =WORKDAY.INTL($K$2,$K$3,16,$K$2) 11/06/14 41949 TRUE =WORKDAY.INTL($K$2,$K$3,17,$K$2) 10/28/14 41940 TRUE =WORKDAY.INTL(DATE(2014,11,1),-2,5,{"2014-11-2";"2014-11-3";"2014-11-4"}) #VALUE! error TRUE =WORKDAY.INTL(DATE(2014,11,1),-2,-5,{"2014-11-2";"2014-11-3";"2014-11-4"}) 10/30/14 41942 TRUE =WORKDAY.INTL(DATE(2014,11,1),-2,{1;1;0;0;0;0;0},{"2014-11-2";"2014-11-3";"2014-11-4"}) 10/30/14 41942 TRUE =WORKDAY.INTL(DATE(2014,11,1),-2,{1;1;1;1;1;1;1},{"2014-11-2";"2014-11-3";"2014-11-4"}) #VALUE! error TRUE =WORKDAY.INTL(DATE(2012,1,1),30,0) 04/14/12 41013 TRUE =WORKDAY.INTL(DATE(2012,1,1),90,11) 0 #VALUE! error TRUE =WORKDAY.INTL(DATE(2014,11,1),-2,"1111111",{"2014-11-2";"2014-11-3";"2014-11-4"}) winfried tdf#100446 #VALUE! error TRUE =WORKDAY.INTL(DATE(2014,11,1),-2,"1111111",{"2014-11-2";"2014-11-3";"2014-11-4"}) 10/14/14 41926 TRUE =WORKDAY.INTL(DATE(2014,11,1),-8,"0011001",{"2014-10-20";"2014-10-23";"2014-10-24"}) 10/15/14 41927 TRUE =WORKDAY.INTL(DATE(2014,11,1),-8,"0000111",{"2014-10-20";"2014-10-23";"2014-10-24"}) #VALUE! error TRUE =WORKDAY.INTL(DATE(2014,11,1),-8,{0;0;1;1;0;0;1},{"2014-10-20";"2014-10-23";"2014-10-24"}) #VALUE! error TRUE =WORKDAY.INTL(K2,-K1,{1;0;0;1;0;0;1}) #VALUE! error TRUE =WORKDAY.INTL(K2,-K1,{0;0;0;1;0;0;1}) #VALUE! error TRUE =WORKDAY.INTL(K2,-K1,{1;0;0;1;0;0;0}) #VALUE! error TRUE =WORKDAY.INTL(K2,K1,{0;0;0;0;0;1;1}) 10/25/14 41937 TRUE =WORKDAY.INTL($K$2;$K$14;3;$K$2) 11/07/14 41950 TRUE =WORKDAY.INTL(K2;K3;{1;0;0;1;0;0;0}) #N/A #N/A TRUE =WORKDAY.INTL(K2;K3;{M1:M7}) 11/07/14 41950 TRUE =WORKDAY.INTL(K2;K3;{M1:M7}) 11/07/14 41950 TRUE =WORKDAY.INTL(K2;K3;{M1:M7}) #VALUE! error TRUE =WORKDAY.INTL(K2;K3;{M1:M7}) #VALUE! error TRUE =WORKDAY.INTL(K2;K3;{M1:M7}) #VALUE! error TRUE =WORKDAY.INTL(K2;K3;{M1:M7}) 3 #VALUE! error TRUE =WORKDAY.INTL(K2;K3;{M1:M7}) 06/21/16 42542 TRUE =WORKDAY.INTL(K$1;1;;K2) 6/20/2016 06/22/16 42543 TRUE =WORKDAY.INTL(K$1;1;"1100000";K3) 6/20/2016 #VALUE! #NUM! TRUE =WORKDAY.INTL(K$1;1;1111111;K4) 1 06/21/16 42542 TRUE =WORKDAY.INTL(K$1;1;"0000011";K5) 06/27/16 42548 TRUE =WORKDAY.INTL(K$1;1;"0111111";K6) #VALUE! #VALUE! TRUE =WORKDAY.INTL(K$1;1;K7) a #VALUE! #VALUE! TRUE =WORKDAY.INTL(K$1;1;K8) #VALUE! #VALUE! TRUE =WORKDAY.INTL(K$1;1;K9) 1 06/21/16 42542 TRUE =WORKDAY.INTL(K$1;1;K10) 12 06/22/16 42543 TRUE =WORKDAY.INTL(K$1;1;K11) 1100000 #VALUE! #NUM! TRUE =WORKDAY.INTL(K$1;1;K12) 1100000 06/22/16 42543 TRUE =WORKDAY.INTL(K$1;1;K13) 1100000 #VALUE! #NUM! TRUE =WORKDAY.INTL(K$1;1;1100000) 06/21/16 42542 TRUE =WORKDAY.INTL(K$1;1;11) 4