{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["set","delete","set VBA","Delete VBA","VBA cell color","VBA Modify"],"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":"set","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Set Cell Value If Date Is Greater Than Today"]
[]
[null,"Product","Delivery Date","Status"]
[null,"Mouse","2022-01-11",{"$f":"IF(C5>=TODAY(),\"Delayed\",\"On time\")","v":"On time"}]
[null,"Keyboard","2022-12-15",{"$f":"IF(C6>=TODAY(),\"Delayed\",\"On time\")","v":"Delayed"}]
[null,"RAM","2022-01-08","On time"]
[null,"Hard Disk","2022-01-18","On time"]
[null,"Speaker","2022-11-05","Delayed"]
[null,"Battery","2022-01-25","On time"]

{"sheet":"delete","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete Cell Value If Date Is Greater Than Today"]
[]
[null,"Product","Delivery Date","Status"]
[null,"Mouse","2022-01-11",{"$f":"IF(C5>=TODAY(),\"\",\"On Time\")","v":"On Time"}]
[null,"Keyboard","2022-12-15",{"$f":"IF(C6>=TODAY(),\"\",\"On Time\")","v":""}]
[null,"RAM","2022-01-08","On Time"]
[null,"Hard Disk","2022-01-18","On Time"]
[null,"Speaker","2022-11-05",""]
[null,"Battery","2022-01-25","On Time"]

{"sheet":"set VBA","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Set Cell Value with VBA If Date Is Greater Than Today"]
[]
[null,"Product","Delivery Date","Status"]
[null,"Mouse","2022-01-11",{"$f":"IF(C5>=TODAY(),\"Delayed\",\"On Time\")","v":"On Time"}]
[null,"Keyboard","2022-12-15",{"$f":"IF(C6>=TODAY(),\"Delayed\",\"On Time\")","v":"Delayed"}]
[null,"RAM","2022-01-08","On Time"]
[null,"Hard Disk","2022-01-18","On Time"]
[null,"Speaker","2022-11-05","Delayed"]
[null,"Battery","2022-01-25","On Time"]

{"sheet":"Delete VBA","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Delete Cell Value with VBA If Date Is Greater Than Today"]
[]
[null,"Product","Delivery Date","Status"]
[null,"Mouse","2022-01-11",{"$f":"IF(C5>=TODAY(),\" \",\"On Time\")","v":"On Time"}]
[null,"Keyboard","2022-12-15",{"$f":"IF(C6>=TODAY(),\" \",\"On Time\")","v":" "}]
[null,"RAM","2022-01-08","On Time"]
[null,"Hard Disk","2022-01-18","On Time"]
[null,"Speaker","2022-11-05"," "]
[null,"Battery","2022-01-25","On Time"]

{"sheet":"VBA cell color","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Change Cell Color with VBA If Date Is Greater Than Today"]
[]
[null,"Product","Delivery Date"]
[null,"Mouse","2022-01-11"]
[null,"Keyboard","2022-12-15"]
[null,"RAM","2022-01-08"]
[null,"Hard Disk","2022-11-18"]
[null,"Speaker","2022-11-05"]
[null,"Battery","2022-01-01"]

{"sheet":"VBA Modify","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Modify Cell Value with VBA If Date Is Greater Than Today"]
[]
[null,"Product","Delivery Date","Status",null,"Deadline","Date"]
[null,"Mouse","2022-01-11",{"$f":"IF(AND(C5>=$G$5,C5>=$G$6),\"Delayed\",\"On Time\")","v":"On Time"},null,"Starts","2022-01-10"]
[null,"Keyboard","2022-01-15",{"$f":"IF(AND(C6>=$G$5,C6>=$G$6),\"Delayed\",\"On Time\")","v":"On Time"},null,"Ends",{"$f":"TODAY()","v":"2022-08-29"}]
[null,"RAM","2022-11-08","Delayed"]
[null,"Hard Disk","2022-01-18","On Time"]
[null,"Speaker","2022-12-12","Delayed"]
[null,"Battery","2022-01-25","On Time"]