2016-05-26T16:38:23.158699521P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 0 0 38680 51674 view1 1 8 0 0 0 0 2 0 0 0 0 0 100 60 true 5 85 0 0 0 0 2 0 0 0 82 0 100 60 true Sheet1 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 true true 3 1 true 1 true jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== false 0 Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč $ - $ . . - - ??? Page 1 ??? (???) 00.00.0000, 00:00:00 Page 1 / 99 DATEDIF Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple DATEDIF formulas with local references and values Function Expected Correct FunctionString Comment d m y ym md yd 365 365 PRAVDA =DATEDIF($K2;$L2;K$1) 2011-02-01 2012-02-01 29 29 PRAVDA =DATEDIF($K3;$L3;K$1) 2012-02-01 2012-03-01 365 365 PRAVDA =DATEDIF($K4;$L4;K$1) 2012-03-28 2013-03-28 366 366 PRAVDA =DATEDIF($K5;$L5;K$1) 2012-03-28 2013-03-29 364 364 PRAVDA =DATEDIF($K6;$L6;K$1) 2012-03-29 2013-03-28 365 365 PRAVDA =DATEDIF($K7;$L7;K$1) 2012-02-29 2013-02-28 366 366 PRAVDA =DATEDIF($K8;$L8;K$1) 2012-02-29 2013-03-01 366 366 PRAVDA =DATEDIF($K9;$L9;K$1) 2011-02-28 2012-02-29 367 367 PRAVDA =DATEDIF($K10;$L10;K$1) 2011-02-28 2012-03-01 32 32 PRAVDA =DATEDIF($K11;$L11;K$1) 2011-01-28 2011-03-01 31 31 PRAVDA =DATEDIF($K12;$L12;K$1) 2011-01-29 2011-03-01 426 426 PRAVDA =DATEDIF($K13;$L13;K$1) 2001-01-01 2002-03-03 700 700 PRAVDA =DATEDIF($K14;$L14;K$1) 2001-06-05 2003-05-06 304 304 PRAVDA =DATEDIF($K15;$L15;K$1) 2001-03-03 2002-01-01 760 760 PRAVDA =DATEDIF($K16;$L16;K$1) 2001-05-06 2003-06-05 8724 8724 PRAVDA =DATEDIF($K17;$L17;K$1) 1988-06-22 2012-05-11 12 12 PRAVDA =DATEDIF($K2;$L2;L$1) 1 1 PRAVDA =DATEDIF($K3;$L3;L$1) 12 12 PRAVDA =DATEDIF($K4;$L4;L$1) 12 12 PRAVDA =DATEDIF($K5;$L5;L$1) 11 11 PRAVDA =DATEDIF($K6;$L6;L$1) 11 11 PRAVDA =DATEDIF($K7;$L7;L$1) 12 12 PRAVDA =DATEDIF($K8;$L8;L$1) 12 12 PRAVDA =DATEDIF($K9;$L9;L$1) 12 12 PRAVDA =DATEDIF($K10;$L10;L$1) 1 1 PRAVDA =DATEDIF($K11;$L11;L$1) 1 1 PRAVDA =DATEDIF($K12;$L12;L$1) 14 14 PRAVDA =DATEDIF($K13;$L13;L$1) 23 23 PRAVDA =DATEDIF($K14;$L14;L$1) 9 9 PRAVDA =DATEDIF($K15;$L15;L$1) 24 24 PRAVDA =DATEDIF($K16;$L16;L$1) 286 286 PRAVDA =DATEDIF($K17;$L17;L$1) 1 1 PRAVDA =DATEDIF($K2;$L2;M$1) 0 0 PRAVDA =DATEDIF($K3;$L3;M$1) 1 1 PRAVDA =DATEDIF($K4;$L4;M$1) 1 1 PRAVDA =DATEDIF($K5;$L5;M$1) 0 0 PRAVDA =DATEDIF($K6;$L6;M$1) 0 0 PRAVDA =DATEDIF($K7;$L7;M$1) 1 1 PRAVDA =DATEDIF($K8;$L8;M$1) 1 1 PRAVDA =DATEDIF($K9;$L9;M$1) 1 1 PRAVDA =DATEDIF($K10;$L10;M$1) 0 0 PRAVDA =DATEDIF($K11;$L11;M$1) 0 0 PRAVDA =DATEDIF($K12;$L12;M$1) 1 1 PRAVDA =DATEDIF($K13;$L13;M$1) 1 1 PRAVDA =DATEDIF($K14;$L14;M$1) 0 0 PRAVDA =DATEDIF($K15;$L15;M$1) 2 2 PRAVDA =DATEDIF($K16;$L16;M$1) 23 23 PRAVDA =DATEDIF($K17;$L17;M$1) 0 0 PRAVDA =DATEDIF($K2;$L2;N$1) 1 1 PRAVDA =DATEDIF($K3;$L3;N$1) 0 0 PRAVDA =DATEDIF($K4;$L4;N$1) 0 0 PRAVDA =DATEDIF($K5;$L5;N$1) 11 11 PRAVDA =DATEDIF($K6;$L6;N$1) 11 11 PRAVDA =DATEDIF($K7;$L7;N$1) 0 0 PRAVDA =DATEDIF($K8;$L8;N$1) 0 0 PRAVDA =DATEDIF($K9;$L9;N$1) 0 0 PRAVDA =DATEDIF($K10;$L10;N$1) 1 1 PRAVDA =DATEDIF($K11;$L11;N$1) 1 1 PRAVDA =DATEDIF($K12;$L12;N$1) 2 2 PRAVDA =DATEDIF($K13;$L13;N$1) 11 11 PRAVDA =DATEDIF($K14;$L14;N$1) 9 9 PRAVDA =DATEDIF($K15;$L15;N$1) 0 0 PRAVDA =DATEDIF($K16;$L16;N$1) 10 10 PRAVDA =DATEDIF($K17;$L17;N$1) 0 0 PRAVDA =DATEDIF($K2;$L2;O$1) 0 0 PRAVDA =DATEDIF($K3;$L3;O$1) 0 0 PRAVDA =DATEDIF($K4;$L4;O$1) 1 1 PRAVDA =DATEDIF($K5;$L5;O$1) 27 27 PRAVDA =DATEDIF($K6;$L6;O$1) 30 30 PRAVDA =DATEDIF($K7;$L7;O$1) 0 0 PRAVDA =DATEDIF($K8;$L8;O$1) 1 1 PRAVDA =DATEDIF($K9;$L9;O$1) 2 2 PRAVDA =DATEDIF($K10;$L10;O$1) 1 1 PRAVDA =DATEDIF($K11;$L11;O$1) 0 0 PRAVDA =DATEDIF($K12;$L12;O$1) 2 2 PRAVDA =DATEDIF($K13;$L13;O$1) 1 1 PRAVDA =DATEDIF($K14;$L14;O$1) 29 29 PRAVDA =DATEDIF($K15;$L15;O$1) 30 30 PRAVDA =DATEDIF($K16;$L16;O$1) 19 19 PRAVDA =DATEDIF($K17;$L17;O$1) 0 0 PRAVDA =DATEDIF($K2;$L2;P$1) 29 29 PRAVDA =DATEDIF($K3;$L3;P$1) 0 0 PRAVDA =DATEDIF($K4;$L4;P$1) 1 1 PRAVDA =DATEDIF($K5;$L5;P$1) 364 364 PRAVDA =DATEDIF($K6;$L6;P$1) 365 365 PRAVDA =DATEDIF($K7;$L7;P$1) 0 0 PRAVDA =DATEDIF($K8;$L8;P$1) 1 1 PRAVDA =DATEDIF($K9;$L9;P$1) 2 2 PRAVDA =DATEDIF($K10;$L10;P$1) 32 32 PRAVDA =DATEDIF($K11;$L11;P$1) 31 31 PRAVDA =DATEDIF($K12;$L12;P$1) 61 61 PRAVDA =DATEDIF($K13;$L13;P$1) 335 335 PRAVDA =DATEDIF($K14;$L14;P$1) 304 304 PRAVDA =DATEDIF($K15;$L15;P$1) 30 30 PRAVDA =DATEDIF($K16;$L16;P$1) 324 324 PRAVDA =DATEDIF($K17;$L17;P$1) 9 9 PRAVDA =DATEDIF(F98;G98;H98) 2007-01-01 2007-01-10 d 0 0 PRAVDA =DATEDIF(F99;G99;H99) 2007-01-01 2007-01-31 m 1 1 PRAVDA =DATEDIF(F100;G100;H100) 2007-01-01 2007-02-01 m 1 1 PRAVDA =DATEDIF(F101;G101;H101) 2007-01-01 2007-02-28 m 364 364 PRAVDA =DATEDIF(F102;G102;H102) 2007-01-01 2007-12-31 d 0 0 PRAVDA =DATEDIF(F103;G103;H103) 2007-01-01 2007-01-31 y 547 547 PRAVDA =DATEDIF(F104;G104;H104) 2007-01-01 2008-07-01 d 18 18 PRAVDA =DATEDIF(F105;G105;H105) 2007-01-01 2008-07-01 m 6 6 PRAVDA =DATEDIF(F106;G106;H106) 2007-01-01 2008-07-01 ym 182 182 PRAVDA =DATEDIF(F107;G107;H107) 2007-01-01 2008-07-01 yd 181 181 PRAVDA =DATEDIF(F108;G108;H108) 2008-01-01 2009-07-01 yd 30 30 PRAVDA =DATEDIF(F109;G109;H109) 2007-01-01 2007-01-31 md 0 0 PRAVDA =DATEDIF(F110;G110;H110) 01.02.2007 01.03.2009 md 0 0 PRAVDA =DATEDIF(F111;G111;H111) 01.02.2008 01.03.2009 md 2 2 PRAVDA =DATEDIF(F112;G112;H112) tdf#105548 01/01/2017 08:00 AM 01/03/17 07:00 AM d 4