{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,6,4,20],[5,3,5,4],[5,5,5,6],[5,8,5,9],[6,11,6,23],[10,17,10,23]]}
[null,null,null,null,null,null,"المطلوب عد ايام الجمعه او السبت  ( او الايام التي احددها)  خلال الفتره التي احدها  كما هو موضح"]
[]
[]
[]
[]
[null,null,null,"الاجازه الاسبوعيه",null,"الفترة من ",null,null,"ايام التوقف"]
[null,null,null,"Friday","Saturday","2024-05-01","2024-05-25",null,"ايام ",{"$f":"COUNTIF(E8:E37,D7)+COUNTIF(E8:E37,E7)","v":10},null,"اريد Reng COUNTIF يكون محصور بين التاريخين المحددين في الخليه F7 , G7"]
[null,null,null,"2024-04-26",{"$f":"TEXT(D8,\"dddd\")","v":"Friday"}]
[null,null,null,{"$f":"D8+1","v":"2024-04-27"},{"$f":"TEXT(D9,\"dddd\")","v":"Saturday"}]
[null,null,null,{"$f":"D9+1","v":"2024-04-28"},{"$f":"TEXT(D10,\"dddd\")","v":"Sunday"}]
[null,null,null,"2024-04-29","Monday",null,null,null,null,"COUNTIF((MATCH(F7,E8:E37,0)):(MATCH(G7,E8:E37,0)),D7)",null,null,null,null,null,null,null,"ماهو الخطأ في هذه الصيغه"]
[null,null,null,"2024-04-30","Tuesday"]
[null,null,null,"2024-05-01","Wednesday"]
[null,null,null,"2024-05-02","Thursday","2024-05-01","2024-05-25",1,"Sunday",{"$f":"CountWkDay(F14,G14,H14)","v":3}]
[null,null,null,"2024-05-03","Friday","2024-05-01","2024-05-25",2,"Monday",{"$f":"CountWkDay(F15,G15,H15)","v":3}]
[null,null,null,"2024-05-04","Saturday","2024-05-01","2024-05-25",3,"Tuesday",3]
[null,null,null,"2024-05-05","Sunday","2024-05-01","2024-05-25",4,"Wednesday",4]
[null,null,null,"2024-05-06","Monday","2024-05-01","2024-05-25",5,"Thursday",4]
[null,null,null,"2024-05-07","Tuesday","2024-05-01","2024-05-25",6,"Friday",4]
[null,null,null,"2024-05-08","Wednesday","2024-05-01","2024-05-25",7,"Saturday",4]
[null,null,null,"2024-05-09","Thursday"]
[null,null,null,"2024-05-10","Friday"]
[null,null,null,"2024-05-11","Saturday"]
[null,null,null,"2024-05-12","Sunday"]
[null,null,null,"2024-05-13","Monday"]
[null,null,null,"2024-05-14","Tuesday"]
[null,null,null,"2024-05-15","Wednesday"]
[null,null,null,"2024-05-16","Thursday"]
[null,null,null,"2024-05-17","Friday"]
[null,null,null,"2024-05-18","Saturday"]
[null,null,null,"2024-05-19","Sunday"]
[null,null,null,"2024-05-20","Monday"]
[null,null,null,"2024-05-21","Tuesday"]
[null,null,null,"2024-05-22","Wednesday"]
[null,null,null,"2024-05-23","Thursday"]
[null,null,null,"2024-05-24","Friday"]
[null,null,null,"2024-05-25","Saturday"]