{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Formula","IF","Conditional Formatting","VBA","Within 30 Days"],"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Student-wise Submission Dates"]
[]
[null,"First Name","Last Name","Submission Date"]
[null,"Harry","Albert","2022-06-10"]
[null,"Charles","Fred","2022-06-25"]
[null,"Arthur","Henry","2022-07-15"]
[null,"Maria","Shilutze","2022-07-28"]
[null,"Jack","Daniel","2022-07-30"]
[null,"Richard","Orlson","2022-08-05"]
[null,"David","Mario","2022-08-13"]
[null,"Howard","Anton","2022-09-02"]
[null,"Alfred","Nobel","2022-09-05"]
[null,"Leo","Tolostoy","2022-09-12"]

{"sheet":"Formula","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Formula to Determine IF Date Is Less than Today",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Submission Date","Less than Today",null,null,null,"First Name","Last Name","Submission Date","Less than Today"]
[null,"Harry","Albert","2022-06-10",{"$f":"D5<TODAY()","v":true},null,null,null,"Harry","Albert","2022-06-10"]
[null,"Charles","Fred","2022-06-25",{"$f":"D6<TODAY()","v":true},null,null,null,"Charles","Fred","2022-06-25"]
[null,"Arthur","Henry","2022-07-15",true,null,null,null,"Arthur","Henry","2022-07-15"]
[null,"Maria","Shilutze","2022-07-28",true,null,null,null,"Maria","Shilutze","2022-07-28"]
[null,"Jack","Daniel","2022-07-30",true,null,null,null,"Jack","Daniel","2022-07-30"]
[null,"Richard","Orlson","2022-08-05",true,null,null,null,"Richard","Orlson","2022-08-05"]
[null,"David","Mario","2022-08-13",true,null,null,null,"David","Mario","2022-08-13"]
[null,"Howard","Anton","2022-09-02",false,null,null,null,"Howard","Anton","2022-09-02"]
[null,"Alfred","Nobel","2022-09-05",false,null,null,null,"Alfred","Nobel","2022-09-05"]
[null,"Leo","Tolostoy","2022-09-12",false,null,null,null,"Leo","Tolostoy","2022-09-12"]

{"sheet":"IF","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Utilizing IF Function to Determine IF Date Is Less than Today",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Submission Date","Status",null,null,null,"First Name","Last Name","Submission Date","Status"]
[null,"Harry","Albert","2022-06-10",{"$f":"IF(D5<TODAY(),\"Submitted\",\"Not Submitted\")","v":"Submitted"},null,null,null,"Harry","Albert","2022-06-10"]
[null,"Charles","Fred","2022-06-25",{"$f":"IF(D6<TODAY(),\"Submitted\",\"Not Submitted\")","v":"Submitted"},null,null,null,"Charles","Fred","2022-06-25"]
[null,"Arthur","Henry","2022-07-15","Submitted",null,null,null,"Arthur","Henry","2022-07-15"]
[null,"Maria","Shilutze","2022-07-28","Submitted",null,null,null,"Maria","Shilutze","2022-07-28"]
[null,"Jack","Daniel","2022-07-30","Submitted",null,null,null,"Jack","Daniel","2022-07-30"]
[null,"Richard","Orlson","2022-08-05","Submitted",null,null,null,"Richard","Orlson","2022-08-05"]
[null,"David","Mario","2022-08-13","Submitted",null,null,null,"David","Mario","2022-08-13"]
[null,"Howard","Anton","2022-09-02","Not Submitted",null,null,null,"Howard","Anton","2022-09-02"]
[null,"Alfred","Nobel","2022-09-05","Not Submitted",null,null,null,"Alfred","Nobel","2022-09-05"]
[null,"Leo","Tolostoy","2022-09-12","Not Submitted",null,null,null,"Leo","Tolostoy","2022-09-12"]

{"sheet":"Conditional Formatting","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Applying Conditional Formatting",null,null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Submission Date",null,null,null,"First Name","Last Name","Submission Date"]
[null,"Harry","Albert","2022-06-10",null,null,null,"Harry","Albert","2022-06-10"]
[null,"Charles","Fred","2022-06-25",null,null,null,"Charles","Fred","2022-06-25"]
[null,"Arthur","Henry","2022-07-15",null,null,null,"Arthur","Henry","2022-07-15"]
[null,"Maria","Shilutze","2022-07-28",null,null,null,"Maria","Shilutze","2022-07-28"]
[null,"Jack","Daniel","2022-07-30",null,null,null,"Jack","Daniel","2022-07-30"]
[null,"Richard","Orlson","2022-08-05",null,null,null,"Richard","Orlson","2022-08-05"]
[null,"David","Mario","2022-08-13",null,null,null,"David","Mario","2022-08-13"]
[null,"Howard","Anton","2022-09-02",null,null,null,"Howard","Anton","2022-09-02"]
[null,"Alfred","Nobel","2022-09-05",null,null,null,"Alfred","Nobel","2022-09-05"]
[null,"Leo","Tolostoy","2022-09-12",null,null,null,"Leo","Tolostoy","2022-09-12"]

{"sheet":"VBA","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Employing VBA Code",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Submission Date","Status",null,null,null,"First Name","Last Name","Submission Date","Status"]
[null,"Harry","Albert","2022-06-10","Submitted",null,null,null,"Harry","Albert","2022-06-10"]
[null,"Charles","Fred","2022-06-25","Submitted",null,null,null,"Charles","Fred","2022-06-25"]
[null,"Arthur","Henry","2022-07-15","Submitted",null,null,null,"Arthur","Henry","2022-07-15"]
[null,"Maria","Shilutze","2022-07-28","Submitted",null,null,null,"Maria","Shilutze","2022-07-28"]
[null,"Jack","Daniel","2022-07-30","Submitted",null,null,null,"Jack","Daniel","2022-07-30"]
[null,"Richard","Orlson","2022-08-05","Submitted",null,null,null,"Richard","Orlson","2022-08-05"]
[null,"David","Mario","2022-08-13","Submitted",null,null,null,"David","Mario","2022-08-13"]
[null,"Howard","Anton","2022-09-02","Not Submitted",null,null,null,"Howard","Anton","2022-09-02"]
[null,"Alfred","Nobel","2022-09-05","Not Submitted",null,null,null,"Alfred","Nobel","2022-09-05"]
[null,"Leo","Tolostoy","2022-09-12","Not Submitted",null,null,null,"Leo","Tolostoy","2022-09-12"]

{"sheet":"Within 30 Days","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Less than Today and within 30 Days",null,null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Submission Date",null,null,null,"First Name","Last Name","Submission Date"]
[null,"Harry","Albert","2022-06-10",null,null,null,"Harry","Albert","2022-06-10"]
[null,"Charles","Fred","2022-06-25",null,null,null,"Charles","Fred","2022-06-25"]
[null,"Arthur","Henry","2022-07-15",null,null,null,"Arthur","Henry","2022-07-15"]
[null,"Maria","Shilutze","2022-07-28",null,null,null,"Maria","Shilutze","2022-07-28"]
[null,"Jack","Daniel","2022-07-30",null,null,null,"Jack","Daniel","2022-07-30"]
[null,"Richard","Orlson","2022-08-05",null,null,null,"Richard","Orlson","2022-08-05"]
[null,"David","Mario","2022-08-13",null,null,null,"David","Mario","2022-08-13"]
[null,"Howard","Anton","2022-09-02",null,null,null,"Howard","Anton","2022-09-02"]
[null,"Alfred","Nobel","2022-09-05",null,null,null,"Alfred","Nobel","2022-09-05"]
[null,"Leo","Tolostoy","2022-09-12",null,null,null,"Leo","Tolostoy","2022-09-12"]