{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["IF","IF, AND","IF, MEDIAN","IF, AND, MIN, MAX","VLOOKUP","XLOOKUP","VBA","HighLighting"],"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":"IF","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Using IF Function"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"IF(B5<=$F$5,$E$5,$E$6)","v":"On time"},null,"On time","2022-08-14"]
[null,"2022-08-13",{"$f":"IF(B6<=$F$5,$E$5,$E$6)","v":"On time"},null,"Late","After 8/14/2022"]
[null,"2022-08-14","On time"]
[null,"2022-08-15","Late"]
[null,"2022-08-16","Late"]
[null,"2022-08-17","Late"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]

{"sheet":"IF, AND","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Combining IF with AND Function"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"IF(AND(B5>=$F$5,\nB5<=$F$6),\n\"On time\",\"Late\")","v":"On time"},null,"Starting Date","2022-08-10"]
[null,"2022-08-13",{"$f":"IF(AND(B6>=$F$5,\nB6<=$F$6),\n\"On time\",\"Late\")","v":"On time"},null,"Deadline","2022-08-15"]
[null,"2022-08-14","On time"]
[null,"2022-08-15","On time"]
[null,"2022-08-16","Late"]
[null,"2022-08-17","Late"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]

{"sheet":"IF, MEDIAN","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Utilizing IF with MEDIAN Function"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"IF(B5=MEDIAN($F$6,$F$5,B5),\n\"On time\",\"Late\")","v":"On time"},null,"Starting Date ","2022-08-10"]
[null,"2022-08-13",{"$f":"IF(B6=MEDIAN($F$6,$F$5,B6),\n\"On time\",\"Late\")","v":"On time"},null,"Deadline","2022-08-15"]
[null,"2022-08-14","On time"]
[null,"2022-08-15","On time"]
[null,"2022-08-16","Late"]
[null,"2022-08-17","Late"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]

{"sheet":"IF, AND, MIN, MAX","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Utilizing IF, MIN and MAX Functions"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"IF(AND(B5>=MIN($F$5:$F$6),\nB5<=MAX($F$5:$F$6)),\n\"On time\",\"Late\")","v":"On time"},null,"Starting Date","2022-08-10"]
[null,"2022-08-13",{"$f":"IF(AND(B6>=MIN($F$5:$F$6),\nB6<=MAX($F$5:$F$6)),\n\"On time\",\"Late\")","v":"On time"},null,"Deadline","2022-08-15"]
[null,"2022-08-14","On time"]
[null,"2022-08-15","On time"]
[null,"2022-08-16","Late"]
[null,"2022-08-17","Late"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]

{"sheet":"VLOOKUP","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Use of VLOOKUP Function"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"VLOOKUP(B5,$E$5:$F$7,\n2,TRUE)","v":"On time"},null,"2022-08-12","On time"]
[null,"2022-08-13",{"$f":"VLOOKUP(B6,$E$5:$F$7,\n2,TRUE)","v":"On time"},null,"2022-08-16","Little Behind"]
[null,"2022-08-14","On time",null,"2022-08-18","Late"]
[null,"2022-08-15","On time"]
[null,"2022-08-16","Little Behind"]
[null,"2022-08-17","Little Behind"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]

{"sheet":"XLOOKUP","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Applying XLOOKUP Function"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"_xlfn.XLOOKUP(B5,$E$5:$E$7,\n$F$5:$F$7,,-1)","v":"On time"},null,"2022-08-12","On time"]
[null,"2022-08-13",{"$f":"_xlfn.XLOOKUP(B6,$E$5:$E$7,\n$F$5:$F$7,,-1)","v":"On time"},null,"2022-08-16","Little Behind"]
[null,"2022-08-14","On time",null,"2022-08-18","Late"]
[null,"2022-08-15","On time"]
[null,"2022-08-16","Little Behind"]
[null,"2022-08-17","Little Behind"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]

{"sheet":"VBA","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"IF(B5<=$F$5,$E$5,$E$6)","v":"On time"},null,"On time","2022-08-14"]
[null,"2022-08-13",{"$f":"IF(B6<=$F$5,$E$5,$E$6)","v":"On time"},null,"Late","After 8/14/2022"]
[null,"2022-08-14","On time"]
[null,"2022-08-15","Late"]
[null,"2022-08-16","Late"]
[null,"2022-08-17","Late"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]

{"sheet":"HighLighting","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Highlighting If Date Is Between Two Dates"]
[]
[null,"Project Submission Date","Remarks",null,"Submission Schedule"]
[null,"2022-08-12",{"$f":"IF(B5<=$F$5,$E$5,$E$6)","v":"On time"},null,"On time","2022-08-14"]
[null,"2022-08-13",{"$f":"IF(B6<=$F$5,$E$5,$E$6)","v":"On time"},null,"Late","After 8/14/2022"]
[null,"2022-08-14","On time"]
[null,"2022-08-15","Late"]
[null,"2022-08-16","Late"]
[null,"2022-08-17","Late"]
[null,"2022-08-18","Late"]
[null,"2022-08-19","Late"]