{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","IF","IF, DAYS","DATEDIF","VBA","Calculator"],"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":"Dataset","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,2]]}
[]
[null,"Calculating Overdue Days"]
[]
[null,"Name","Subject","Submission Date","Overdue"]
[null,"Karen","Physics","2022-01-10"]
[null,"Susan","Chemistry","2022-01-11"]
[null,"John","Math","2022-01-20"]
[null,"Stacy","Database","2022-01-14"]
[null,"Phillips","Literature","2022-01-11"]
[null,"Max","Math","2022-01-15"]
[null,"Elizabeth","Biology","2022-01-09"]
[]
[null,"Last Date of Submission",null,"2022-01-11"]

{"sheet":"IF","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,2]]}
[]
[null,"Using IF with Subtraction Formula"]
[]
[null,"Name","Subject","Submission Date","Overdue"]
[null,"Karen","Physics","2022-01-10",{"$f":"IF(D5=$D$13,\"Submitted Today\",IF(D5<$D$13,\"No Overdue\",(D5-$D$13)&\" Days Overdue\"))","v":"No Overdue"}]
[null,"Susan","Chemistry","2022-01-11",{"$f":"IF(D6=$D$13,\"Submitted Today\",IF(D6<$D$13,\"No Overdue\",(D6-$D$13)&\" Days Overdue\"))","v":"Submitted Today"}]
[null,"John","Math","2022-01-20","9 Days Overdue"]
[null,"Stacy","Database","2022-01-14","3 Days Overdue"]
[null,"Phillips","Literature","2022-01-11","Submitted Today"]
[null,"Max","Math","2022-01-15","4 Days Overdue"]
[null,"Elizabeth","Biology","2022-01-09","No Overdue"]
[]
[null,"Last Date of Submission",null,"2022-01-11"]

{"sheet":"IF, DAYS","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,2]]}
[]
[null,"Utilizing IF and DAYS Functions"]
[]
[null,"Name","Subject","Submission Date","Overdue"]
[null,"Karen","Physics","2022-01-10",{"$f":"IF(D5>$D$13,_xlfn.DAYS(D5,$D$13) & \" Days Overdue\",\"No Overdue\")","v":"No Overdue"}]
[null,"Susan","Chemistry","2022-01-11",{"$f":"IF(D6>$D$13,_xlfn.DAYS(D6,$D$13) & \" Days Overdue\",\"No Overdue\")","v":"No Overdue"}]
[null,"John","Math","2022-01-20","9 Days Overdue"]
[null,"Stacy","Database","2022-01-14","3 Days Overdue"]
[null,"Phillips","Literature","2022-01-11","No Overdue"]
[null,"Max","Math","2022-01-15","4 Days Overdue"]
[null,"Elizabeth","Biology","2022-01-09","No Overdue"]
[]
[null,"Last Date of Submission",null,"2022-01-11"]

{"sheet":"DATEDIF","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,2]]}
[]
[null,"Combining IF with DATEDIF Function"]
[]
[null,"Name","Subject","Submission Date","Overdue"]
[null,"Karen","Physics","2022-01-10",{"$f":"IF(ISERROR(DATEDIF(D5,$D$13,\"d\")),D5-$D$13&\" Days Overdue\",\"No Overdue\")","v":"No Overdue"}]
[null,"Susan","Chemistry","2022-01-11",{"$f":"IF(ISERROR(DATEDIF(D6,$D$13,\"d\")),D6-$D$13&\" Days Overdue\",\"No Overdue\")","v":"No Overdue"}]
[null,"John","Math","2022-01-20","9 Days Overdue"]
[null,"Stacy","Database","2022-01-14","3 Days Overdue"]
[null,"Phillips","Literature","2022-01-11","No Overdue"]
[null,"Max","Math","2022-01-15","4 Days Overdue"]
[null,"Elizabeth","Biology","2022-01-09","No Overdue"]
[]
[null,"Last Date of Submission",null,"2022-01-11"]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,2]]}
[]
[null,"Using VBA"]
[]
[null,"Name","Subject","Submission Date","Overdue"]
[null,"Karen","Physics","2022-01-10","No Overdue"]
[null,"Susan","Chemistry","2022-01-11","Submitted Today"]
[null,"John","Math","2022-01-20","9 Days Overdue"]
[null,"Stacy","Database","2022-01-14","3 Days Overdue"]
[null,"Phillips","Literature","2022-01-11","Submitted Today"]
[null,"Max","Math","2022-01-15","4 Days Overdue"]
[null,"Elizabeth","Biology","2022-01-09","No Overdue"]
[]
[null,"Last Date of Submission",null,"2022-01-11"]

{"sheet":"Calculator","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,6,4,6],[1,1,1,7],[3,7,4,7]]}
[]
[null,"Using IF with Subtraction Formula"]
[]
[null,"Name","Subject","Submission Date","Overdue",null,"Last Date of Submission","2022-01-11"]
[null,"Karen","Physics","2022-01-10",{"$f":"IF(D5=$H$4,\"Submitted Today\",IF(D5<$H$4,\"No Overdue\",(D5-$H$4)&\" Days Overdue\"))","v":"No Overdue"}]
[null,"Susan","Chemistry","2022-01-11",{"$f":"IF(D6=$H$4,\"Submitted Today\",IF(D6<$H$4,\"No Overdue\",(D6-$H$4)&\" Days Overdue\"))","v":"Submitted Today"}]
[null,"John","Math","2022-01-20",{"$f":"IF(D7=$H$4,\"Submitted Today\",IF(D7<$H$4,\"No Overdue\",(D7-$H$4)&\" Days Overdue\"))","v":"9 Days Overdue"}]
[null,"Stacy","Database","2022-01-14",{"$f":"IF(D8=$H$4,\"Submitted Today\",IF(D8<$H$4,\"No Overdue\",(D8-$H$4)&\" Days Overdue\"))","v":"3 Days Overdue"}]
[null,"Phillips","Literature","2022-01-11",{"$f":"IF(D9=$H$4,\"Submitted Today\",IF(D9<$H$4,\"No Overdue\",(D9-$H$4)&\" Days Overdue\"))","v":"Submitted Today"}]
[null,"Max","Math","2022-01-15",{"$f":"IF(D10=$H$4,\"Submitted Today\",IF(D10<$H$4,\"No Overdue\",(D10-$H$4)&\" Days Overdue\"))","v":"4 Days Overdue"}]
[null,"Elizabeth","Biology","2022-01-09",{"$f":"IF(D11=$H$4,\"Submitted Today\",IF(D11<$H$4,\"No Overdue\",(D11-$H$4)&\" Days Overdue\"))","v":"No Overdue"}]
[null,null,null,"2022-01-31",{"$f":"IF(D12=$H$4,\"Submitted Today\",IF(D12<$H$4,\"No Overdue\",(D12-$H$4)&\" Days Overdue\"))","v":"20 Days Overdue"}]