{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Keyboard Shortcut","Today Function","Now Function","IF & Now","VBA","AutoFill","Fill Series"],"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":"Keyboard Shortcut","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Keyboard Shortcut"]
[]
[null,"Using CTRL + ; ","2021-06-22"]
[]
[null,"Using CTRL + Shift + ;","11:26:00"]
[]
[null,"CTRL + ; \nthen SPACE\nthen CTRL + Shift + ;","2021-06-22T11:30:00"]

{"sheet":"Today Function","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing TODAY Function"]
[]
[null,"Today's Date",{"$f":"TODAY()","v":"2022-11-13"}]
[]
[null,"Enter Yours"]

{"sheet":"Now Function","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying NOW Function"]
[]
[null,"Current Date & Time",{"$f":"NOW()","v":"2022-11-13T23:47:14.920"}]
[]
[null,"Enter Yours"]

{"sheet":"IF & Now","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,4],[1,1,1,2]]}
[]
[null,"Using IF and NOW Function"]
[]
[null,"Name","Entry Time"]
[null,"Andrew",{"$f":"IF(B5<>\"\",IF(C5=\"\",NOW(),C5),\"\")","v":"2022-11-13T09:11:58.740"}]
[null,"Mike","2022-11-13T09:13:08.720"]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,"<<< Put Any Name & Find Timestamp"]

{"sheet":"VBA","index":4,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA"]
[]
[null,"Name","Entry Time"]
[null,"Andrew",{"$f":"EntryTime(B5)","v":{"$error":"#NAME?"}}]

{"sheet":"AutoFill","index":5,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Utilizing AutoFill Feature"]
[]
[null,"Autofill Days"]
[null,"2021-06-22"]
[null,"2022-06-22"]
[null,"2023-06-22"]
[null,"2024-06-22"]
[null,"2025-06-22"]
[null,"2026-06-22"]
[null,"2027-06-22"]
[null,"2028-06-22"]
[null,"2029-06-22"]
[null,"2030-06-22"]
[null,"2031-06-22"]

{"sheet":"Fill Series","index":6,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Utilizing Fill Series Command"]
[]
[null,"Using Fill Series"]
[null,"2021-06-22"]
[null,"2023-06-22"]
[null,"2025-06-22"]
[null,"2027-06-22"]
[null,"2029-06-22"]
[null,"2031-06-22"]
[null,"2033-06-22"]
[null,"2035-06-22"]
[null,"2037-06-22"]
[null,"2039-06-22"]
[null,"2041-06-22"]
[null,"2043-06-22"]