{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Дата"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Дата","index":0,"n_rows":111,"n_cols":6,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["ДАТА","ДАТА",null,null,"2014-01-01"]
["27.07.2013","27.07.2013",null,null,"2014-02-01"]
["13.10.2013","13.10.2013","Условие 1:","Посчитать все ячейки, в которых дата стоит 2014 год",{"$f":"COUNTIFS(A2:A300,\">=\"&$E$1)","v":0},{"$f":"COUNTIF(A2:A999,TEXT(E1,\"\\*.ГГГ\"))","v":88}]
["22.10.2013","22.10.2013","Условие 2:","Посчитать все ячейки, в которых дата стоит до 1.02.14",{"$f":"COUNTIFS(A2:A300,\"<=\"&$E$2)","v":0},{"$f":"SUMPRODUCT(ISTEXT(A2:A999)*(--A2:A999<E2))","v":24}]
["26.10.2013","26.10.2013"]
["07.11.2013","07.11.2013"]
["15.12.2013","15.12.2013"]
["15.12.2013","15.12.2013"]
["17.12.2013","17.12.2013"]
["20.12.2013","20.12.2013"]
["20.12.2013","20.12.2013"]
["07.01.2014","07.01.2014"]
["13.01.2014","13.01.2014"]
["13.01.2014","13.01.2014"]
["13.01.2014","13.01.2014"]
["13.01.2014","13.01.2014"]
["13.01.2014","13.01.2014"]
["13.01.2014","13.01.2014"]
["14.01.2014","14.01.2014"]
["15.01.2014","15.01.2014"]
["15.01.2014","15.01.2014"]
["23.01.2014","23.01.2014"]
["28.01.2014","28.01.2014"]
["28.01.2014","28.01.2014"]
["31.01.2014","31.01.2014"]
["03.02.2014","03.02.2014"]
["04.02.2014","04.02.2014"]
["06.02.2014","06.02.2014"]
["06.02.2014","06.02.2014"]
["07.02.2014","07.02.2014"]
["10.02.2014","10.02.2014"]
["17.02.2014","17.02.2014"]
["17.02.2014","17.02.2014"]
["17.02.2014","17.02.2014"]
["17.02.2014","17.02.2014"]
["19.02.2014","19.02.2014"]
["19.02.2014","19.02.2014"]
["20.02.2014","20.02.2014"]
["20.02.2014","20.02.2014"]
["20.02.2014","20.02.2014"]
["20.02.2014","20.02.2014"]
["20.02.2014","20.02.2014"]
["21.02.2014","21.02.2014"]
["24.02.2014","24.02.2014"]
["26.02.2014","26.02.2014"]
["02.03.2014","02.03.2014"]
["03.03.2014","03.03.2014"]
["03.03.2014","03.03.2014"]
["05.03.2014","05.03.2014"]
["05.03.2014","05.03.2014"]
["08.03.2014","08.03.2014"]
["10.03.2014","10.03.2014"]
["10.03.2014","10.03.2014"]
["10.03.2014","10.03.2014"]
["10.03.2014","10.03.2014"]
["07.03.2014","07.03.2014"]
["07.03.2014","07.03.2014"]
["07.03.2014","07.03.2014"]
["07.03.2014","07.03.2014"]
["07.03.2014","07.03.2014"]
["07.03.2014","07.03.2014"]
["07.03.2014","07.03.2014"]
["10.03.2014","10.03.2014"]
["08.03.2014","08.03.2014"]
["13.03.2014","13.03.2014"]
["16.03.2014","16.03.2014"]
["16.03.2014","16.03.2014"]
["13.03.2014","13.03.2014"]
["16.03.2014","16.03.2014"]
["18.03.2014","18.03.2014"]
["18.03.2014","18.03.2014"]
["18.03.2014","18.03.2014"]
["18.03.2014","18.03.2014"]
["18.03.2014","18.03.2014"]
["21.03.2014","21.03.2014"]
["21.03.2014","21.03.2014"]
["21.03.2014","21.03.2014"]
["21.03.2014","21.03.2014"]
["21.03.2014","21.03.2014"]
["21.03.2014","21.03.2014"]
["21.03.2014","21.03.2014"]
["21.03.2014","21.03.2014"]
["23.03.2014","23.03.2014"]
["24.03.2014","24.03.2014"]
["24.03.2014","24.03.2014"]
["24.03.2014","24.03.2014"]
["24.03.2014","24.03.2014"]
["24.03.2014","24.03.2014"]
["24.03.2014","24.03.2014"]
["24.03.2014","24.03.2014"]
["25.03.2014","25.03.2014"]
["25.03.2014","25.03.2014"]
["25.03.2014","25.03.2014"]
["25.03.2014","25.03.2014"]
["30.03.2014","30.03.2014"]
["26.03.2014","26.03.2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["29.03.2014","29.03.2014"]
[]
["30.03.2014","30.03.2014"]
[]
["30.03.2014","30.03.2014"]