{"text_format":"1","workbook":"xlsx","n_sheets":2,"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":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$f":"IF('المناسبات والأعياد'!$F$4>=1,\"باقى\"&'المناسبات والأعياد'!$F$4&\" يوم على \" &VLOOKUP('المناسبات والأعياد'!$F$4,'المناسبات والأعياد'!$B$2:$E$16,4,0),\"\")","v":"باقى51 يوم على عيد تحرير سيناء"},"باقى6 يوم على عيد الثورة(ثورة 23 يوليو)"]
[]
["المطلوب الاستغناء عن ورقة الأعياد والمناسبات - وايضاً الاستغناء عن a3"]
["اريد فقط ان يظهر في اليوزر فورم عدد الأيام المتبقي علي المناسابات"]

{"sheet":"المناسبات والأعياد","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["الترتيب","فرق الأيام","تاريخ","يوم","الإجازات"]
[{"$f":"IF(B2<1,\"\",RANK(B2,$B$2:$B$16,0))","v":""},{"$f":"$C2-TODAY()","v":-58},{"$f":"DATE(YEAR(TODAY()),1,7)","v":"2020-01-07"},{"$f":"TEXT(C2,\"b2 dddd\")","v":" الثلاثاء"},"عيد الميلاد القبطي",null,null,null,null,null,null,null,null,null,1,"محرم"]
["",{"$f":"$C3-TODAY()","v":-40},{"$f":"DATE(YEAR(TODAY()),1,25)","v":"2020-01-25"},{"$f":"TEXT(C3,\"b2 dddd\")","v":" السبت"},"ثورة 25 يناير",null,null,null,null,null,null,null,null,null,2,"صفر "]
[12,51,{"$f":"DATE(YEAR(TODAY()),4,25)","v":"2020-04-25"}," السبت","عيد تحرير سيناء",{"$f":"MIN(IF($B$2:$B$16>=1,$B$2:$B$16))","v":51},null,null,null,null,null,null,null,null,3,"ربيع الأول"]
[11,54,{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2020-04-28"}," الثلاثاء","عيد الفصح القبطي",null,null,null,null,null,null,null,null,null,4,"ربيع الثانى"]
[10,55,{"$f":"DATE(YEAR(TODAY()),4,29)","v":"2020-04-29"}," الأربعاء","عيد شم النسيم",null,null,null,null,null,null,null,null,null,5,"جمادى الأول"]
[9,57,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2020-05-01"}," الجمعة","عيد العمال",null,null,null,null,null,null,null,null,null,6,"جمادى الثانى"]
[8,78,{"$f":"J8","v":"22/05/2020"}," الجمعة"," وقفة عيد الفطر المبارك",null,null,null,null,{"$f":"ConvertDate(N8)","v":"22/05/2020"},{"$f":"TEXT(TODAY(),\"b2 yyy\")","v":" 1441"},"رمضان",30,{"$f":"M8&\"/\"&L8&\"/\"&K8","v":"30/رمضان/ 1441"},7,"رجب"]
[7,79,{"$f":"J9","v":"23/05/2020"}," السبت","أجازة عيد الفطر المبارك",null,null,null,null,{"$f":"ConvertDate(N9)","v":"23/05/2020"},{"$f":"TEXT(TODAY(),\"b2 yyy\")","v":" 1441"},"شوال",1,"1/شوال/ 1441",8,"شعبان"]
[6,117,{"$f":"DATE(YEAR(TODAY()),6,30)","v":"2020-06-30"}," الثلاثاء","ثورة 30 يونيو",null,null,null,null,null,null,null,null,null,9,"رمضان"]
[5,140,{"$f":"DATE(YEAR(TODAY()),7,23)","v":"2020-07-23"}," الخميس","عيد الثورة(ثورة 23 يوليو)",null,null,null,null,null,null,null,null,null,10,"شوال"]
[4,146,{"$f":"J12","v":"29/07/2020"}," الأربعاء","أجازة يوم وقفة عرفات",null,null,null,null,"29/07/2020"," 1441","ذو الحجة",9,"9/ذو الحجة/ 1441",11,"ذو القعدة"]
[3,147,{"$f":"J13","v":"30/07/2020"}," الخميس","عيد الأضحى المبارك",null,null,null,null,"30/07/2020"," 1441","ذو الحجة",10,"10/ذو الحجة/ 1441",12,"ذو الحجة"]
[2,167,"19/08/2020"," الأربعاء","رأس السنة الهجرية",null,null,null,null,"19/08/2020"," 1441","ذو الحجة",30,"30/ذو الحجة/ 1441"]
[1,215,{"$f":"DATE(YEAR(TODAY()),10,6)","v":"2020-10-06"}," الثلاثاء","عيد القوات المسلحة"]
["",-117,{"$f":"J16","v":"09/11/2019"}," السبت","عيد المولد النبوى الشريف",null,null,null,null,{"$f":"ConvertDate(N16)","v":"09/11/2019"},{"$f":"TEXT(TODAY(),\"b2 yyyy\")","v":" 1441"},3,12,{"$f":"M16&\"/\"&L16&\"/\"&K16","v":"12/3/ 1441"}]