{"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":13,"n_cols":36,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,4,10,16],[9,1,9,20]]}
[{"$f":"IFERROR(CHOOSE(WEEKDAY(H1),\"الاحد\",\"الاثنين\",\"الثلاثاء\",\"الاربعاء\",\"الخميس\",\"الجمعة\",\"السبت\"),\"\")","v":"الجمعة"},{"$f":"IF(AND($E$1=$I$2,A1=$K$2),TEXT($L$2,\"YYYY/MM/DD\"),IF(AND($E$1=$I$2,A1=$M$2),TEXT($N$2,\"YYYY/MM/DD\"),IF(AND($E$1=$I$3,A1=$K$3),TEXT($L$3,\"YYYY/MM/DD\"),IF(AND($E$1=$I$3,A1=$M$3),TEXT($N$3,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A1=$K$4),TEXT($L$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A1=$M$4),TEXT($N$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A1=$O$4),TEXT($P$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A1=$Q$4),TEXT($R$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A1=$K$5),TEXT($L$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A1=$M$5),TEXT($N$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A1=$O$5),TEXT($P$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A1=$Q$5),TEXT($R$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A1=$S$5),TEXT($T$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A1=$K$6),TEXT($L$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A1=$M$6),TEXT($N$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A1=$O$6),TEXT($P$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A1=$Q$6),TEXT($R$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A1=$S$6),TEXT($T$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A1=$U$6),TEXT($V$6,\"YYYY/MM/DD\"),\"\")))))))))))))))))))","v":""},null,"أيام الدوام","الأثنين والأربعاء",null,{"$f":"IFERROR(CHOOSE(WEEKDAY(H1),\"الاحد\",\"الاثنين\",\"الثلاثاء\",\"الاربعاء\",\"الخميس\",\"الجمعة\",\"السبت\"),\"\")","v":"الجمعة"},{"$f":"IF($E$2<>\"\",TODAY(),\"\")","v":"2020-04-03"},"أيام الدوام"]
[{"$f":"IFERROR(CHOOSE(WEEKDAY(H2),\"الاحد\",\"الاثنين\",\"الثلاثاء\",\"الاربعاء\",\"الخميس\",\"الجمعة\",\"السبت\"),\"\")","v":"السبت"},{"$f":"IF(AND($E$1=$I$2,A2=$K$2),TEXT($L$2,\"YYYY/MM/DD\"),IF(AND($E$1=$I$2,A2=$M$2),TEXT($N$2,\"YYYY/MM/DD\"),IF(AND($E$1=$I$3,A2=$K$3),TEXT($L$3,\"YYYY/MM/DD\"),IF(AND($E$1=$I$3,A2=$M$3),TEXT($N$3,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A2=$K$4),TEXT($L$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A2=$M$4),TEXT($N$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A2=$O$4),TEXT($P$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$4,A2=$Q$4),TEXT($R$4,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A2=$K$5),TEXT($L$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A2=$M$5),TEXT($N$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A2=$O$5),TEXT($P$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A2=$Q$5),TEXT($R$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$5,A2=$S$5),TEXT($T$5,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A2=$K$6),TEXT($L$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A2=$M$6),TEXT($N$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A2=$O$6),TEXT($P$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A2=$Q$6),TEXT($R$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A2=$S$6),TEXT($T$6,\"YYYY/MM/DD\"),IF(AND($E$1=$I$6,A2=$U$6),TEXT($V$6,\"YYYY/MM/DD\"),\"\")))))))))))))))))))","v":""},null,null,{"$f":"IF(E1<>\"\",TODAY(),\"\")","v":"2020-04-03"},null,{"$f":"IFERROR(CHOOSE(WEEKDAY(H2),\"الاحد\",\"الاثنين\",\"الثلاثاء\",\"الاربعاء\",\"الخميس\",\"الجمعة\",\"السبت\"),\"\")","v":"السبت"},{"$f":"IFERROR(IF(H1=\"\",\"\",H1)+1,\"\")","v":"2020-04-04"},"الأحد والثلاثاء",null,{"$f":"IF(AND($E$1<>\"\",I2=\"الاحد والثلاثاء\"),\"الاحد\",\"\")","v":"الاحد"},{"$f":"IFERROR(VLOOKUP(K2,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-05"},{"$f":"IF(AND($E$1<>\"\",I2=\"الاحد والثلاثاء\"),\"الثلاثاء\",\"\")","v":"الثلاثاء"},{"$f":"IFERROR(VLOOKUP(M2,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الأحد والثلاثاء"]
["الاحد","",null,null,{"$f":"IF(AND(E1<>\"\",E1=I2),\"يومين في الاسبوع\",IF(AND(E1<>\"\",E1=I3),\"يومين في الاسبوع\",IF(AND(E1<>\"\",E1=I4),\"من الأحد إلى الأربعاء\",IF(AND(E1<>\"\",E1=I5),\"من الأحد إلى الخميس\",IF(AND(E1<>\"\",E1=I6),\"من السبت إلى الخميس\",\"\")))))","v":"يومين في الاسبوع"},null,"الاحد",{"$f":"IFERROR(IF(H2=\"\",\"\",H2)+1,\"\")","v":"2020-04-05"},"الأثنين والأربعاء",null,{"$f":"IF(AND($E$1<>\"\",I3=\"الاثنين والاربعاء\"),\"الاثنين\",\"\")","v":"الاثنين"},{"$f":"IFERROR(VLOOKUP(K3,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-06"},{"$f":"IF(AND($E$1<>\"\",I3=\"الاثنين والاربعاء\"),\"الاربعاء\",\"\")","v":"الاربعاء"},{"$f":"IFERROR(VLOOKUP(M3,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الأثنين والأربعاء"]
["الاثنين","2020/04/06",null,null,null,null,"الاثنين","2020-04-06","أربعة أيام",null,{"$f":"IF(AND($E$1<>\"\",$I$4=\"أربعة ايام\"),\"الاحد\",\"\")","v":"الاحد"},"2020-04-05",{"$f":"IF(AND($E$1<>\"\",$I$4=\"أربعة ايام\"),\"الاثنين\",\"\")","v":"الاثنين"},{"$f":"IFERROR(VLOOKUP(M4,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-06"},{"$f":"IF(AND($E$1<>\"\",$I$4=\"أربعة ايام\"),\"الثلاثاء\",\"\")","v":"الثلاثاء"},{"$f":"IFERROR(VLOOKUP(O4,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-07"},{"$f":"IF(AND($E$1<>\"\",$I$4=\"أربعة ايام\"),\"الاربعاء\",\"\")","v":"الاربعاء"},{"$f":"IFERROR(VLOOKUP(Q4,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"أربعة أيام"]
["الثلاثاء","",null,null,null,null,"الثلاثاء","2020-04-07","خمسة أيام",null,{"$f":"IF(AND($E$1<>\"\",$I$5=\"خمسة ايام\"),\"الاحد\",\"\")","v":"الاحد"},"2020-04-05",{"$f":"IF(AND($E$1<>\"\",$I$5=\"خمسة ايام\"),\"الاثنين\",\"\")","v":"الاثنين"},"2020-04-06",{"$f":"IF(AND($E$1<>\"\",$I$5=\"خمسة ايام\"),\"الثلاثاء\",\"\")","v":"الثلاثاء"},{"$f":"IFERROR(VLOOKUP(O5,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-07"},{"$f":"IF(AND($E$1<>\"\",$I$5=\"خمسة ايام\"),\"الاربعاء\",\"\")","v":"الاربعاء"},{"$f":"IFERROR(VLOOKUP(Q5,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-08"},{"$f":"IF(AND($E$1<>\"\",$I$5=\"خمسة ايام\"),\"الخميس\",\"\")","v":"الخميس"},{"$f":"IFERROR(VLOOKUP(S5,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-09"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خمسة أيام"]
["الاربعاء","2020/04/08",null,null,null,null,"الاربعاء","2020-04-08","ستة ايام",null,{"$f":"IF(AND($E$1<>\"\",$I$6=\"ستة ايام\"),\"السبت\",\"\")","v":"السبت"},"2020-04-04",{"$f":"IF(AND($E$1<>\"\",$I$6=\"ستة ايام\"),\"الاحد\",\"\")","v":"الاحد"},"2020-04-05",{"$f":"IF(AND($E$1<>\"\",$I$6=\"ستة ايام\"),\"الاثنين\",\"\")","v":"الاثنين"},"2020-04-06",{"$f":"IF(AND($E$1<>\"\",$I$6=\"ستة ايام\"),\"الثلاثاء\",\"\")","v":"الثلاثاء"},"2020-04-07",{"$f":"IF(AND($E$1<>\"\",$I$6=\"ستة ايام\"),\"الاربعاء\",\"\")","v":"الاربعاء"},{"$f":"IFERROR(VLOOKUP(S6,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-08"},{"$f":"IF(AND($E$1<>\"\",$I$6=\"ستة ايام\"),\"الخميس\",\"\")","v":"الخميس"},{"$f":"IFERROR(VLOOKUP(U6,$G$1:$H$7,2,FALSE),\"\")","v":"2020-04-09"},null,null,null,null,null,null,null,null,null,null,null,null,null,"ستة ايام"]
["الخميس","",null,null,null,null,"الخميس","2020-04-09"]
[]
[]
[null,"المطلوب تعبئة تاريخ اليوم تلقائي في العمود  B وذلك من خلال الشرط في الخلية E1  ويكون عدد الأيام المراد تعبئتها بناء على العدد المذكور في الخلية E3     ويبدأ التاريخ من الخليه    E2 "]
[null,null,null,null,"مثال / لو كتبنا في خلية الاحد والثلاثاء فالمطلوب تعبئة العمود بتاريخ الأحد والثلاثاء  من كل اسبوع "]
[]
[null,{"$f":"O6","v":"الاثنين"}]