2016-05-26T15:42:48.977846871P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 0 0 22009 4261 view1 2 12 0 0 0 0 2 0 0 0 0 0 100 60 true 3 20 0 0 0 0 2 0 0 0 0 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 DATE Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple DATE formulas with local references and values Function Expected Correct FunctionString Comment 31.01.1983 31.01.1983 PRAVDA DATE(1983;1;31) 31.01.1983 31.01.1983 PRAVDA DATE(year;month;day) 31.01.1983 31.01.1983 PRAVDA DATE(J4;J5;J6) 1983 3 31.12.1982 31.12.1982 PRAVDA DATE(J4;;J6) missing month / If the values for month and day are out of bounds, they are carried over to the next digit. If you enter =DATE(00;12;31) the result will be 12/31/00. If, on the other hand, you enter =DATE(00;13;31) the result will be 1/31/01. 1 6 Err:511 #error PRAVDA DATE(;J5;J6) missing year 31 2002 31.12.1982 31.12.1982 PRAVDA DATE(J4;J5;) missing day 03.06.2002 03.06.2002 PRAVDA DATE(L6;L5;L4) The year formatted as text 31.12.2000 31.12.2000 PRAVDA DATE(0;12;31) 31.01.2001 31.01.2001 PRAVDA DATE(0;13;31) 31.12.1982 31.12.1982 PRAVDA DATE(J4;0;J6) 31.12.1982 31.12.1982 PRAVDA DATE(J4;J5;0) 30.12.1982 30.12.1982 PRAVDA DATE(J4;J5;-1) 30.11.1999 30.11.1999 PRAVDA DATE(0;0;0) Year 0 is evaluated as a year with 1 or 2 digits => 2000 => date 2000-01-01Month 0 decrements the date by 1 month => 1999-12-01Day 0 decrements the date by 1 day => 1999-11-30 01.10.2001 01.10.2001 PRAVDA DATE(1;10;1) 01.01.2010 01.01.2010 PRAVDA DATE(10;1;1) #VALUE! #VALUE! PRAVDA DATE(100;1;1) The #VALUE! because the Gregorian calendar starts in year 1583, welikely could do better there and use the prolapsing Gregorian calendarfor earlier dates, but the help states that. We do recognize earlierdates in cell input, like 100-01-01 => 0100-01-01 or 099-01-01 =>0099-01-01 and can calculate with them. #VALUE! #VALUE! PRAVDA DATE(1000;1;1) 01.01.1899 01.01.1899 PRAVDA DATE(1899;1;1) 01.01.1900 01.01.1900 PRAVDA DATE(1900;1;1) Age 4