{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Format Cells","VALUE Function","TEXT Function ","Keyboard Shortcuts","Number Feature","Mathematical Operator","VBA Code","8-Digit Number to Date"],"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":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Serial Numbers"]
[]
[null,"Serial Number","Expected Format"]
[null,44474,"mm/dd/yyyy"]
[null,44475,"mm/dd/yyyy"]
[null,44476,"mm/dd/yyyy"]
[null,44477,"mm/dd/yyyy"]
[null,44478,"mm/dd/yyyy"]
[null,44479,"mm/dd/yyyy"]
[null,44480,"mm/dd/yyyy"]
[null,44481,"mm/dd/yyyy"]
[null,7957,"mm/dd/yyyy"]
[null,7958,"mm/dd/yyyy"]
[null,7959,"mm/dd/yyyy"]
[null,7960,"mm/dd/yyyy"]

{"sheet":"Format Cells","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using Format Cells Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Serial Number","Equivalent Date",null,null,null,null,null,null,null,null,"Serial Number","Equivalent Date"]
[null,44474,"2021-10-05",null,null,null,null,null,null,null,null,44474]
[null,44475,"2021-10-06",null,null,null,null,null,null,null,null,44475]
[null,44476,"2021-10-07",null,null,null,null,null,null,null,null,44476]
[null,44477,"2021-10-08",null,null,null,null,null,null,null,null,44477]
[null,44478,"2021-10-09",null,null,null,null,null,null,null,null,44478]
[null,44479,"2021-10-10",null,null,null,null,null,null,null,null,44479]
[null,44480,"2021-10-11",null,null,null,null,null,null,null,null,44480]
[null,44481,"2021-10-12",null,null,null,null,null,null,null,null,44481]
[null,7957,"1921-10-13",null,null,null,null,null,null,null,null,7957]
[null,7958,"1921-10-14",null,null,null,null,null,null,null,null,7958]
[null,7959,"1921-10-15",null,null,null,null,null,null,null,null,7959]
[null,7960,"1921-10-16",null,null,null,null,null,null,null,null,7960]

{"sheet":"VALUE Function","index":2,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using VALUE Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Serial Number","Equivalent Date",null,null,null,null,null,null,null,null,"Serial Number","Equivalent Date"]
[null,44474,{"$f":"VALUE(B5)","v":"2021-10-05"},null,null,null,null,null,null,null,null,44474]
[null,44475,{"$f":"VALUE(B6)","v":"2021-10-06"},null,null,null,null,null,null,null,null,44475]
[null,44476,"2021-10-07",null,null,null,null,null,null,null,null,44476]
[null,44477,"2021-10-08",null,null,null,null,null,null,null,null,44477]
[null,44478,"2021-10-09",null,null,null,null,null,null,null,null,44478]
[null,44479,"2021-10-10",null,null,null,null,null,null,null,null,44479]
[null,44480,"2021-10-11",null,null,null,null,null,null,null,null,44480]
[null,44481,"2021-10-12",null,null,null,null,null,null,null,null,44481]
[null,7957,"1921-10-13",null,null,null,null,null,null,null,null,7957]
[null,7958,"1921-10-14",null,null,null,null,null,null,null,null,7958]
[null,7959,"1921-10-15",null,null,null,null,null,null,null,null,7959]
[null,7960,"1921-10-16",null,null,null,null,null,null,null,null,7960]

{"sheet":"TEXT Function ","index":3,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using TEXT Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Serial Number","Equivalent Date",null,null,null,null,null,null,null,null,"Serial Number","Equivalent Date"]
[null,44474,{"$f":"TEXT(B5,\"mm/dd/yyyy\")","v":"10/05/2021"},null,null,null,null,null,null,null,null,44474]
[null,44475,{"$f":"TEXT(B6,\"mm/dd/yyyy\")","v":"10/06/2021"},null,null,null,null,null,null,null,null,44475]
[null,44476,"10/07/2021",null,null,null,null,null,null,null,null,44476]
[null,44477,"10/08/2021",null,null,null,null,null,null,null,null,44477]
[null,44478,"10/09/2021",null,null,null,null,null,null,null,null,44478]
[null,44479,"10/10/2021",null,null,null,null,null,null,null,null,44479]
[null,44480,"10/11/2021",null,null,null,null,null,null,null,null,44480]
[null,44481,"10/12/2021",null,null,null,null,null,null,null,null,44481]
[null,7957,"10/13/1921",null,null,null,null,null,null,null,null,7957]
[null,7958,"10/14/1921",null,null,null,null,null,null,null,null,7958]
[null,7959,"10/15/1921",null,null,null,null,null,null,null,null,7959]
[null,7960,"10/16/1921",null,null,null,null,null,null,null,null,7960]

{"sheet":"Keyboard Shortcuts","index":4,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Serial Number","Equivalent Date",null,null,null,null,null,null,null,null,"Serial Number","Equivalent Date"]
[null,44474,"2021-10-05",null,null,null,null,null,null,null,null,44474]
[null,44475,"2021-10-06",null,null,null,null,null,null,null,null,44475]
[null,44476,"2021-10-07",null,null,null,null,null,null,null,null,44476]
[null,44477,"2021-10-08",null,null,null,null,null,null,null,null,44477]
[null,44478,"2021-10-09",null,null,null,null,null,null,null,null,44478]
[null,44479,"2021-10-10",null,null,null,null,null,null,null,null,44479]
[null,44480,"2021-10-11",null,null,null,null,null,null,null,null,44480]
[null,44481,"2021-10-12",null,null,null,null,null,null,null,null,44481]
[null,7957,"1921-10-13",null,null,null,null,null,null,null,null,7957]
[null,7958,"1921-10-14",null,null,null,null,null,null,null,null,7958]
[null,7959,"1921-10-15",null,null,null,null,null,null,null,null,7959]
[null,7960,"1921-10-16",null,null,null,null,null,null,null,null,7960]

{"sheet":"Number Feature","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using Number Feature",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Serial Number","Short Date","Long Date",null,null,null,null,null,null,null,"Serial Number","Short Date","Long Date"]
[null,44474,"2021-10-05","2021-10-05",null,null,null,null,null,null,null,44474]
[null,44475,"2021-10-06","2021-10-06",null,null,null,null,null,null,null,44475]
[null,44476,"2021-10-07","2021-10-07",null,null,null,null,null,null,null,44476]
[null,44477,"2021-10-08","2021-10-08",null,null,null,null,null,null,null,44477]
[null,44478,"2021-10-09","2021-10-09",null,null,null,null,null,null,null,44478]
[null,44479,"2021-10-10","2021-10-10",null,null,null,null,null,null,null,44479]
[null,44480,"2021-10-11","2021-10-11",null,null,null,null,null,null,null,44480]
[null,44481,"2021-10-12","2021-10-12",null,null,null,null,null,null,null,44481]
[null,7957,"1921-10-13","1921-10-13",null,null,null,null,null,null,null,7957]
[null,7958,"1921-10-14","1921-10-14",null,null,null,null,null,null,null,7958]
[null,7959,"1921-10-15","1921-10-15",null,null,null,null,null,null,null,7959]
[null,7960,"1921-10-16","1921-10-16",null,null,null,null,null,null,null,7960]

{"sheet":"Mathematical Operator","index":6,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Using Mathematical Operators",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Serial Number","Equivalent Date","Formula ",null,null,null,null,null,null,null,"Serial Number","Equivalent Date"]
[null,44474,{"$f":"B5+0","v":"2021-10-05"},"=B4+0",null,null,null,null,null,null,null,44474]
[null,44475,{"$f":"B6+0","v":"2021-10-06"},"=B5+0",null,null,null,null,null,null,null,44475]
[null,44476,{"$f":"--B7","v":"2021-10-07"},"=--B6",null,null,null,null,null,null,null,44476]
[null,44477,{"$f":"--B8","v":"2021-10-08"},"=--B7",null,null,null,null,null,null,null,44477]
[null,44478,{"$f":"B9*1","v":"2021-10-09"},"=B9*1",null,null,null,null,null,null,null,44478]
[null,44479,{"$f":"B10*1","v":"2021-10-10"},"=B10*1",null,null,null,null,null,null,null,44479]
[null,44480,"2021-10-11","=B11*1",null,null,null,null,null,null,null,44480]
[null,44481,"2021-10-12","=B12*1",null,null,null,null,null,null,null,44481]
[null,7957,{"$f":"B13/1","v":"1921-10-13"},"=B14/1",null,null,null,null,null,null,null,7957]
[null,7958,{"$f":"B14/1","v":"1921-10-14"},"=B15/1",null,null,null,null,null,null,null,7958]
[null,7959,"1921-10-15","=B16/1",null,null,null,null,null,null,null,7959]
[null,7960,"1921-10-16","=B17/1",null,null,null,null,null,null,null,7960]

{"sheet":"VBA Code","index":7,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Serial Number","Equivalent Date",null,null,null,null,null,null,null,null,"Serial Number","Equivalent Date"]
[null,44474,"2021-10-05",null,null,null,null,null,null,null,null,44474]
[null,44475,"2021-10-06",null,null,null,null,null,null,null,null,44475]
[null,44476,"2021-10-07",null,null,null,null,null,null,null,null,44476]
[null,44477,"2021-10-08",null,null,null,null,null,null,null,null,44477]
[null,44478,"2021-10-09",null,null,null,null,null,null,null,null,44478]
[null,44479,"2021-10-10",null,null,null,null,null,null,null,null,44479]
[null,44480,"2021-10-11",null,null,null,null,null,null,null,null,44480]
[null,44481,"2021-10-12",null,null,null,null,null,null,null,null,44481]
[null,7957,"1921-10-13",null,null,null,null,null,null,null,null,7957]
[null,7958,"1921-10-14",null,null,null,null,null,null,null,null,7958]
[null,7959,"1921-10-15",null,null,null,null,null,null,null,null,7959]
[null,7960,"1921-10-16",null,null,null,null,null,null,null,null,7960]

{"sheet":"8-Digit Number to Date","index":8,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Converting 8-Digit Number to Date",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"8-Digit Number","Equivalent Date",null,null,null,null,null,null,null,null,"8-Digit Number","Equivalent Date"]
[null,10032016,{"$f":"DATE(RIGHT(B5,4), MID(B5,3,2), LEFT(B5,2))","v":"2016-03-10"},null,null,null,null,null,null,null,null,10032016]
[null,12112019,{"$f":"DATE(RIGHT(B6,4), MID(B6,3,2), LEFT(B6,2))","v":"2019-11-12"},null,null,null,null,null,null,null,null,12112019]
[null,11022012,"2012-02-11",null,null,null,null,null,null,null,null,11022012]
[null,12122012,"2012-12-12",null,null,null,null,null,null,null,null,12122012]
[null,11092015,"2015-09-11",null,null,null,null,null,null,null,null,11092015]
[null,20102020,"2020-10-20",null,null,null,null,null,null,null,null,20102020]
[null,21022002,"2002-02-21",null,null,null,null,null,null,null,null,21022002]
[null,31122021,"2021-12-31",null,null,null,null,null,null,null,null,31122021]
[null,30112008,"2008-11-30",null,null,null,null,null,null,null,null,30112008]
[null,17042017,"2017-04-17",null,null,null,null,null,null,null,null,17042017]
[null,29082000,"2000-08-29",null,null,null,null,null,null,null,null,29082000]
[null,18062001,"2001-06-18",null,null,null,null,null,null,null,null,18062001]