{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Format Date","Specific Date Format","Example"],"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":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Format Date with VBA"]
[]
[null,"Date","Formatted Date"]
[null,"2022-01-11","2022-01-11"]
[null,"2022-01-11","2022-01-11"]
[null,"2022-01-11","2022-01-11"]
[null,"2022-01-11","2022-01-11"]
[null,"2022-01-11","2022-01-11"]
[null,"2022-01-11","2022-01-11"]
[null,"2022-01-11","2022-01-11"]
[null,"2022-01-11","2022-01-11"]

{"sheet":"Format Date","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Format Date with VBA"]
[]
[null,"Date","Formatted Date","VBA Code"]
[null,"2022-01-11","2022-01-11","Range(\"C5\").NumberFormat = \"dd-mm-yyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C6\").NumberFormat = \"ddd-mm-yyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C7\").NumberFormat = \"dddd-mm-yyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C8\").NumberFormat = \"dd-mmm-yyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C9\").NumberFormat = \"dd-mmmm-yyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C10\").NumberFormat = \"dd-mm-yy\""]
[null,"2022-01-11","2022-01-11","Range(\"C11\").NumberFormat = \"ddd mmm yyyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C12\").NumberFormat = \"dddd mmmm yyyy\""]

{"sheet":"Specific Date Format","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Format Date Based on Specific Value with VBA"]
[]
[null,"Date","Formatted Date","VBA Code"]
[null,"2022-01-11","2022-01-11","Range(\"C5\").NumberFormat = \"dd\""]
[null,"2022-01-11","2022-01-11","Range(\"C6\").NumberFormat = \"ddd\""]
[null,"2022-01-11","2022-01-11","Range(\"C7\").NumberFormat = \"dddd\""]
[null,"2022-01-11","2022-01-11","Range(\"C7\").NumberFormat = \"m\""]
[null,"2022-01-11","2022-01-11","Range(\"C8\").NumberFormat = \"mm\""]
[null,"2022-01-11","2022-01-11","Range(\"C9\").NumberFormat = \"mmm\""]
[null,"2022-01-11","2022-01-11","Range(\"C11\").NumberFormat = \"yy\""]
[null,"2022-01-11","2022-01-11","Range(\"C12\").NumberFormat = \"yyyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C13\").NumberFormat = \"dd-mm\""]
[null,"2022-01-11","2022-01-11","Range(\"C14\").NumberFormat = \"mm-yyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C15\").NumberFormat = \"mmm-yyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C16\").NumberFormat = \"dd-yy\""]
[null,"2022-01-11","2022-01-11","Range(\"C17\").NumberFormat = \"ddd yyyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C18\").NumberFormat = \"dddd-yyyy\""]
[null,"2022-01-11","2022-01-11","Range(\"C19\").NumberFormat = \"dd-mmm\""]
[null,"2022-01-11","2022-01-11","Range(\"C20\").NumberFormat = \"dddd-mmmm\""]

{"sheet":"Example","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Format Date in Specific Sheet with VBA"]
[]
[null,"Date","Formatted Date"]
[null,"2022-01-11","2022-01-11"]