{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["1941-06-22","2020-09-18","à",{"$f":"DATEDIF(A1,B1,\"y\")&\" \"&TEXT(MOD(MAX(MOD(DATEDIF(A1,B1,\"y\")-11,100),9),10),\"[<1]\\го\\д;[<4]\\го\\да;лет\")&\" \"&DATEDIF(A1,B1,\"ym\")&\" меся\"&TEXT(MOD(DATEDIF(A1,B1,\"ym\")-1,11),\"[<1]ц;[<4]ца;цев\")&\" \"&DATEDIF(A1,B1+1,\"md\")&\" д\"&TEXT(MOD(MAX(MOD(DATEDIF(A1,B1+1,\"md\")-11,100),9),10),\"[<1]ень;[<4]ня;ней\")","v":"79 лет 2 месяца 28 дней"},null,{"$f":"РАЗНОСТЬ_ДАТ_1900(A1,B1)","v":"79 лет 2 мес 28 Дней"}]
[{"$f":"WEEKDAY(A1, 1)","v":"1900-01-01"},{"$f":"WEEKDAY(B1, 1)","v":"1900-01-06"},null,{"$f":"TRUNC(DAYS360(DATE(RIGHT(A1,4)+2000,MID(A1,4,2),LEFT(A1,2)),DATE(RIGHT(B1,4)+2000,MID(B1,4,2),LEFT(B1,2)),1)/360)&\" лет \" & TRUNC(MOD(DAYS360(DATE(RIGHT(A1,4)+2000,MID(A1,4,2),LEFT(A1,2)),DATE(RIGHT(B1,4)+2000,MID(B1,4,2),LEFT(B1,2)),1),360)/30)&\" мес \"&MOD(DAYS360(DATE(RIGHT(A1,4)+2000,MID(A1,4,2),LEFT(A1,2)),DATE(RIGHT(B1,4)+2000,MID(B1,4,2),LEFT(B1,2)),1),30)&\" дн\"","v":"-1053 лет 7 мес 28 дн"},{"$f":"B1-DATE(YEAR(A1)+79,MONTH(A1)+2,DAY(A1))","v":27}]
[]
[]
[]
[]
[]
["22.06.1841","18.09.1881","à",{"$f":"DATEDIF(A8,B8,\"y\")&\" \"&TEXT(MOD(MAX(MOD(DATEDIF(A8,B8,\"y\")-11,100),9),10),\"[<1]\\го\\д;[<4]\\го\\да;лет\")&\" \"&DATEDIF(A8,B8,\"ym\")&\" меся\"&TEXT(MOD(DATEDIF(A8,B8,\"ym\")-1,11),\"[<1]ц;[<4]ца;цев\")&\" \"&DATEDIF(A8,B8+1,\"md\")&\" д\"&TEXT(MOD(MAX(MOD(DATEDIF(A8,B8+1,\"md\")-11,100),9),10),\"[<1]ень;[<4]ня;ней\")","v":{"$error":"#VALUE!"}},null,{"$f":"РАЗНОСТЬ_ДАТ_1900(A8,B8)","v":"40 лет 2 мес 28 Дней"}]
[{"$f":"WEEKDAY(A8, 1)","v":{"$error":"#VALUE!"}},{"$f":"WEEKDAY(B8, 1)","v":{"$error":"#VALUE!"}},null,{"$f":"TRUNC(DAYS360(DATE(RIGHT(A8,4)+2000,MID(A8,4,2),LEFT(A8,2)),DATE(RIGHT(B8,4)+2000,MID(B8,4,2),LEFT(B8,2)),0)/360)&\" лет \" & TRUNC(MOD(DAYS360(DATE(RIGHT(A8,4)+2000,MID(A8,4,2),LEFT(A8,2)),DATE(RIGHT(B8,4)+2000,MID(B8,4,2),LEFT(B8,2)),0),360)/30)&\" мес \"&MOD(DAYS360(DATE(RIGHT(A8,4)+2000,MID(A8,4,2),LEFT(A8,2)),DATE(RIGHT(B8,4)+2000,MID(B8,4,2),LEFT(B8,2)),0),30)&\" дн\"","v":"40 лет 2 мес 26 дн"}]
[{"$f":"DATE(RIGHT(A8,4)+2000,MID(A8,4,2),LEFT(A8,2))","v":"3841-06-22"},{"$f":"DATE(RIGHT(B8,4)+2000,MID(B8,4,2),LEFT(B8,2))","v":"3881-09-18"},null,{"$f":"DATEDIF(A10,B10,\"y\")&\" \"&TEXT(MOD(MAX(MOD(DATEDIF(A10,B10,\"y\")-11,100),9),10),\"[<1]\\го\\д;[<4]\\го\\да;лет\")&\" \"&DATEDIF(A10,B10,\"ym\")&\" меся\"&TEXT(MOD(DATEDIF(A10,B10,\"ym\")-1,11),\"[<1]ц;[<4]ца;цев\")&\" \"&DATEDIF(A10,B10+1,\"md\")&\" д\"&TEXT(MOD(MAX(MOD(DATEDIF(A10,B10+1,\"md\")-11,100),9),10),\"[<1]ень;[<4]ня;ней\")","v":"40 лет 2 месяца 28 дней"}]
[{"$f":"WEEKDAY(A10, 1)","v":"1900-01-03"},{"$f":"WEEKDAY(B10, 1)","v":"1900-01-01"},null,null,{"$f":"B10-DATE(YEAR(A10)+40,MONTH(A10)+2,DAY(A10))","v":27}]
[]
[{"$f":"TRUNC(DAYS360(A10,B10,1)/360)&\" лет \" & TRUNC(MOD(DAYS360(A10,B10,1),360)/30)&\" мес \"&MOD(DAYS360(A10,B10,1),30)&\" дн\"","v":"40 лет 2 мес 26 дн"}]
["1933-09-19","2011-10-18",null,null,null,{"$f":"РАЗНОСТЬ_ДАТ_1900(A14,B14)","v":"78 лет 0 мес 30 Дней"}]
[]
[null,null,null,null,null,"2020-09-10"]
[null,null,null,null,null,"2020-09-15"]
[null,null,null,null,null,{"$f":"F17-F16","v":5}]