{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","ورقة2"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,5,0,9],[5,0,5,1],[9,3,9,7],[12,1,12,9]]}
["تاريخ البداية","تاريخ النهاية","عدد الايام بدون استثناء","عدد الايام مع التواريخ المستثناه",null,"التواريخ المستثناه"]
["2019-01-01","2019-01-31",{"$f":"D2-COUNT(E2:J2)","v":14},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A2&\":\"&B2)))<>3)*(WEEKDAY(ROW(INDIRECT(A2&\":\"&B2)))<6))-SUMPRODUCT(--(ROW(INDIRECT(A2&\":\"&B2))=$E$2:$J$2))","v":16},"2019-01-17","2019-01-31",null,null,null,null,null,null,"عدد الأيام"]
[null,null,"صحيح",null,null,null,null,null,null,null,null,"بدون ثلاثاء","بدون الجمعة والسبت"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"2019-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-02"]
[]
[null,null,null,null,"هنا في الحقيقة 18 يوما ليس 19 يوما",null,null,null,null,null,null,null,null,"2019-01-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-05"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-06"]
[null,null,null,"رجاءا الأستاذ سليم أنا أريد العمل في هذا النموذج أما الجدول للإيضاح فقط شكرا مسبقا",null,null,null,null,null,null,null,1,1,"2019-01-07"]
[null,null,null,null,null,"التعديل على هذه المعادلة",null,null,null,null,null,null,1,"2019-01-08"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-09"]
[null,"SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(\"1:\"&(B2-A2)+1))+(A2)-1)<6))-COUNTA(F2:J2;\"Tuesday\";1;0;)",null,null,null,null,null,null,null,null,null,1,1,"2019-01-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-12"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-13"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"2019-01-15"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-16"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-19"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-20"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"2019-01-22"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-23"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-26"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-27"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"2019-01-29"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-30"]
[null,null,null,null,null,null,null,null,null,null,null,1,1,"2019-01-31"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L4:L34)","v":17},{"$f":"SUM(M4:M34)","v":22}]
[null,null,null,null,null,null,null,null,null,null,null,"يوما","يوما"]

{"sheet":"ورقة2","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUMPRODUCT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WEEKDAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ROW"]
[null,null,null,null,null,null,null,null,null,null,null,null,"INDIRECT"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(\"1:\"&(B2-A2)+1))+(A2)-1)<6))-COUNTA(F2:J2;\"Tuesday\";1;0;)"]