{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Using TODAY Function","Using NOW Function","Timestamp Using Excel Options","Timestamp Using Formula","VBA to Insert Date that Updates"],"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":"Using TODAY Function","index":0,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using TODAY Function",null,null,null,null,"Practice Yourself Here"]
[]
[null,"Today is ",{"$f":"TODAY()","v":"2022-10-16"},null,null,null,"Today is "]

{"sheet":"Using NOW Function","index":1,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using NOW Function",null,null,null,null,"Practice Yourself Here"]
[]
[null,"Currently the date and time is",{"$f":"NOW()","v":"2022-10-16T10:45:21.830"},null,null,null,"Currently the date and time is"]

{"sheet":"Timestamp Using Excel Options","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Insert Timestamp Using Excel Options",null,null,null,null,"Practice Yourself Here"]
[]
[null,"Name","Entry Time",null,null,null,"Name","Entry Time"]
[null,"Aston",{"$f":"IF(B5<>\"\",IF(C5<>\"\",C5,NOW()),\"\")","v":"2022-10-16T10:28:01.490"}]
[null,"Harry",{"$f":"IF(B6<>\"\",IF(C6<>\"\",C6,NOW()),\"\")","v":"2022-10-16T10:30:24.300"}]
[null,"Jack","2022-10-16T10:30:24.300"]
[null,"Tom","2022-10-16T10:30:24.300"]
[null,"Charls","2022-10-16T10:30:24.300"]
[null,"Karen","2022-10-16T10:30:24.300"]
[null,"Selena","2022-10-16T10:30:24.300"]
[null,null,{"$f":"IF(B12<>\"\",IF(C12<>\"\",C12,NOW()),\"\")","v":""}]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"Timestamp Using Formula","index":3,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Insert Timestamp Using Formula",null,null,null,null,"Practice Yourself Here"]
[]
[null,"Name","Entry time",null,null,null,"Name","Entry Time"]
[null,"Aston",{"$f":"IF(B5<>\"\",IF(AND(C5<>\"\",CELL(\"address\")=ADDRESS(ROW(B5),COLUMN(B5))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B5),COLUMN(B5)),C5,NOW())),\"\")","v":"2022-10-16T09:57:08.410"}]
[null,"Harry",{"$f":"IF(B6<>\"\",IF(AND(C6<>\"\",CELL(\"address\")=ADDRESS(ROW(B6),COLUMN(B6))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B6),COLUMN(B6)),C6,NOW())),\"\")","v":"2022-10-16T09:57:13.640"}]
[null,"Jack",{"$f":"IF(B7<>\"\",IF(AND(C7<>\"\",CELL(\"address\")=ADDRESS(ROW(B7),COLUMN(B7))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B7),COLUMN(B7)),C7,NOW())),\"\")","v":"2022-10-16T09:57:16.280"}]
[null,"Tom",{"$f":"IF(B8<>\"\",IF(AND(C8<>\"\",CELL(\"address\")=ADDRESS(ROW(B8),COLUMN(B8))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B8),COLUMN(B8)),C8,NOW())),\"\")","v":"2022-10-16T09:57:17.800"}]
[null,"Charls",{"$f":"IF(B9<>\"\",IF(AND(C9<>\"\",CELL(\"address\")=ADDRESS(ROW(B9),COLUMN(B9))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B9),COLUMN(B9)),C9,NOW())),\"\")","v":"2022-10-16T09:57:29.650"}]
[null,"Karen",{"$f":"IF(B10<>\"\",IF(AND(C10<>\"\",CELL(\"address\")=ADDRESS(ROW(B10),COLUMN(B10))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B10),COLUMN(B10)),C10,NOW())),\"\")","v":"2022-10-16T09:57:31.360"}]
[null,"Selena",{"$f":"IF(B11<>\"\",IF(AND(C11<>\"\",CELL(\"address\")=ADDRESS(ROW(B11),COLUMN(B11))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B11),COLUMN(B11)),C11,NOW())),\"\")","v":"2022-10-16T09:57:33.610"}]
[null,null,{"$f":"IF(B12<>\"\",IF(AND(C12<>\"\",CELL(\"address\")=ADDRESS(ROW(B12),COLUMN(B12))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B12),COLUMN(B12)),C12,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B13<>\"\",IF(AND(C13<>\"\",CELL(\"address\")=ADDRESS(ROW(B13),COLUMN(B13))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B13),COLUMN(B13)),C13,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B14<>\"\",IF(AND(C14<>\"\",CELL(\"address\")=ADDRESS(ROW(B14),COLUMN(B14))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B14),COLUMN(B14)),C14,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B15<>\"\",IF(AND(C15<>\"\",CELL(\"address\")=ADDRESS(ROW(B15),COLUMN(B15))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B15),COLUMN(B15)),C15,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B16<>\"\",IF(AND(C16<>\"\",CELL(\"address\")=ADDRESS(ROW(B16),COLUMN(B16))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B16),COLUMN(B16)),C16,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B17<>\"\",IF(AND(C17<>\"\",CELL(\"address\")=ADDRESS(ROW(B17),COLUMN(B17))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B17),COLUMN(B17)),C17,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B18<>\"\",IF(AND(C18<>\"\",CELL(\"address\")=ADDRESS(ROW(B18),COLUMN(B18))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B18),COLUMN(B18)),C18,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B19<>\"\",IF(AND(C19<>\"\",CELL(\"address\")=ADDRESS(ROW(B19),COLUMN(B19))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B19),COLUMN(B19)),C19,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B20<>\"\",IF(AND(C20<>\"\",CELL(\"address\")=ADDRESS(ROW(B20),COLUMN(B20))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B20),COLUMN(B20)),C20,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B21<>\"\",IF(AND(C21<>\"\",CELL(\"address\")=ADDRESS(ROW(B21),COLUMN(B21))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B21),COLUMN(B21)),C21,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B22<>\"\",IF(AND(C22<>\"\",CELL(\"address\")=ADDRESS(ROW(B22),COLUMN(B22))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B22),COLUMN(B22)),C22,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B23<>\"\",IF(AND(C23<>\"\",CELL(\"address\")=ADDRESS(ROW(B23),COLUMN(B23))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B23),COLUMN(B23)),C23,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B24<>\"\",IF(AND(C24<>\"\",CELL(\"address\")=ADDRESS(ROW(B24),COLUMN(B24))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B24),COLUMN(B24)),C24,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B25<>\"\",IF(AND(C25<>\"\",CELL(\"address\")=ADDRESS(ROW(B25),COLUMN(B25))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B25),COLUMN(B25)),C25,NOW())),\"\")","v":""}]

{"sheet":"VBA to Insert Date that Updates","index":4,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Employing VBA to Insert and Update Dates",null,null,null,null,"Practice Yourself Here"]
[]
[null,"Name","Entry time",null,null,null,"Name","Entry Time"]
[null,"Aston","2022-11-10T16:26:48"]
[null,"Harry","2022-11-10T16:26:51"]
[null,"Jack","2022-11-10T16:26:55"]
[null,"Tom","2022-11-10T16:26:59"]
[null,"Charls","2022-11-10T16:27:02"]
[null,"Karen","2022-11-10T16:27:05"]
[null,"Selena","2022-11-10T16:27:09"]
[null,null,{"$f":"IF(B12<>\"\",IF(AND(C12<>\"\",CELL(\"address\")=ADDRESS(ROW(B12),COLUMN(B12))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B12),COLUMN(B12)),C12,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B13<>\"\",IF(AND(C13<>\"\",CELL(\"address\")=ADDRESS(ROW(B13),COLUMN(B13))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B13),COLUMN(B13)),C13,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B14<>\"\",IF(AND(C14<>\"\",CELL(\"address\")=ADDRESS(ROW(B14),COLUMN(B14))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B14),COLUMN(B14)),C14,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B15<>\"\",IF(AND(C15<>\"\",CELL(\"address\")=ADDRESS(ROW(B15),COLUMN(B15))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B15),COLUMN(B15)),C15,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B16<>\"\",IF(AND(C16<>\"\",CELL(\"address\")=ADDRESS(ROW(B16),COLUMN(B16))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B16),COLUMN(B16)),C16,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B17<>\"\",IF(AND(C17<>\"\",CELL(\"address\")=ADDRESS(ROW(B17),COLUMN(B17))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B17),COLUMN(B17)),C17,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B18<>\"\",IF(AND(C18<>\"\",CELL(\"address\")=ADDRESS(ROW(B18),COLUMN(B18))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B18),COLUMN(B18)),C18,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B19<>\"\",IF(AND(C19<>\"\",CELL(\"address\")=ADDRESS(ROW(B19),COLUMN(B19))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B19),COLUMN(B19)),C19,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B20<>\"\",IF(AND(C20<>\"\",CELL(\"address\")=ADDRESS(ROW(B20),COLUMN(B20))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B20),COLUMN(B20)),C20,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B21<>\"\",IF(AND(C21<>\"\",CELL(\"address\")=ADDRESS(ROW(B21),COLUMN(B21))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B21),COLUMN(B21)),C21,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B22<>\"\",IF(AND(C22<>\"\",CELL(\"address\")=ADDRESS(ROW(B22),COLUMN(B22))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B22),COLUMN(B22)),C22,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B23<>\"\",IF(AND(C23<>\"\",CELL(\"address\")=ADDRESS(ROW(B23),COLUMN(B23))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B23),COLUMN(B23)),C23,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B24<>\"\",IF(AND(C24<>\"\",CELL(\"address\")=ADDRESS(ROW(B24),COLUMN(B24))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B24),COLUMN(B24)),C24,NOW())),\"\")","v":""}]
[null,null,{"$f":"IF(B25<>\"\",IF(AND(C25<>\"\",CELL(\"address\")=ADDRESS(ROW(B25),COLUMN(B25))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B25),COLUMN(B25)),C25,NOW())),\"\")","v":""}]