{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":2,"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":"Sheet1","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Year","Month","Date From Year Month","Payment schedule","Payment schedule VBA","Payment schedule VBA"]
[2022,"Oct",{"$f":"DATEVALUE(1&\"/\"&B2&\"/\"&A2)","v":"2022-10-01"},{"$f":"IF(DAY(C2-WEEKDAY(C2,3)+2+7*2)>14,C2-WEEKDAY(C2,3)+2+7,C2-WEEKDAY(C2,3)+2+7*2)","v":"2022-10-12"},{"$f":"Payment_Schedule_VBA(C2,2)","v":"2022-10-12"},{"$f":"Payment_Schedule_VBA_02(C2,2)","v":"2022-10-12"}]
[2022,"Nov",{"$f":"DATEVALUE(1&\"/\"&B3&\"/\"&A3)","v":"2022-11-01"},{"$f":"IF(DAY(C3-WEEKDAY(C3,3)+2+7*2)>14,C3-WEEKDAY(C3,3)+2+7,C3-WEEKDAY(C3,3)+2+7*2)","v":"2022-11-09"},{"$f":"Payment_Schedule_VBA(C3,2)","v":"2022-11-09"},{"$f":"Payment_Schedule_VBA_02(C3,2)","v":"2022-11-09"}]
[2022,"Dec","2022-12-01","2022-12-14",{"$f":"Payment_Schedule_VBA(C4,2)","v":"2022-12-14"},{"$f":"Payment_Schedule_VBA_02(C4,2)","v":"2022-12-14"}]
[2023,"Jan","2023-01-01","2023-01-11",{"$f":"Payment_Schedule_VBA(C5,2)","v":"2023-01-11"},{"$f":"Payment_Schedule_VBA_02(C5,2)","v":"2023-01-11"}]
[2023,"Feb","2023-02-01","2023-02-08",{"$f":"Payment_Schedule_VBA(C6,2)","v":"2023-02-08"},{"$f":"Payment_Schedule_VBA_02(C6,2)","v":"2023-02-08"}]
[2023,"Mar","2023-03-01","2023-03-08",{"$f":"Payment_Schedule_VBA(C7,2)","v":"2023-03-08"},{"$f":"Payment_Schedule_VBA_02(C7,2)","v":"2023-03-08"}]
[2023,"Apr","2023-04-01","2023-04-12",{"$f":"Payment_Schedule_VBA(C8,2)","v":"2023-04-12"},{"$f":"Payment_Schedule_VBA_02(C8,2)","v":"2023-04-12"}]
[2023,"May","2023-05-01","2023-05-10",{"$f":"Payment_Schedule_VBA(C9,2)","v":"2023-05-10"},{"$f":"Payment_Schedule_VBA_02(C9,2)","v":"2023-05-10"}]
[2023,"Jun","2023-06-01","2023-06-14",{"$f":"Payment_Schedule_VBA(C10,2)","v":"2023-06-14"},{"$f":"Payment_Schedule_VBA_02(C10,2)","v":"2023-06-14"}]
[2023,"Jul","2023-07-01","2023-07-12",{"$f":"Payment_Schedule_VBA(C11,2)","v":"2023-07-12"},{"$f":"Payment_Schedule_VBA_02(C11,2)","v":"2023-07-12"}]
[2023,"Aug","2023-08-01","2023-08-09",{"$f":"Payment_Schedule_VBA(C12,2)","v":"2023-08-09"},{"$f":"Payment_Schedule_VBA_02(C12,2)","v":"2023-08-09"}]
[2023,"Sep","2023-09-01","2023-09-13",{"$f":"Payment_Schedule_VBA(C13,2)","v":"2023-09-13"},{"$f":"Payment_Schedule_VBA_02(C13,2)","v":"2023-09-13"}]
[2023,"Oct","2023-10-01","2023-10-11",{"$f":"Payment_Schedule_VBA(C14,2)","v":"2023-10-11"},{"$f":"Payment_Schedule_VBA_02(C14,2)","v":"2023-10-11"}]
[2023,"Nov","2023-11-01","2023-11-08",{"$f":"Payment_Schedule_VBA(C15,2)","v":"2023-11-08"},{"$f":"Payment_Schedule_VBA_02(C15,2)","v":"2023-11-08"}]
[2023,"Dec","2023-12-01","2023-12-13",{"$f":"Payment_Schedule_VBA(C16,2)","v":"2023-12-13"},{"$f":"Payment_Schedule_VBA_02(C16,2)","v":"2023-12-13"}]
[2024,"Jan","2024-01-01","2024-01-10",{"$f":"Payment_Schedule_VBA(C17,2)","v":"2024-01-10"},{"$f":"Payment_Schedule_VBA_02(C17,2)","v":"2024-01-10"}]
[]
["Công thức ô C2"]
[{"$f":"_xlfn.FORMULATEXT(C2)","v":"=DATEVALUE(1&\"/\"&B2&\"/\"&A2)"}]
["Công thức ô D2"]
[{"$f":"_xlfn.FORMULATEXT(D2)","v":"=IF(DAY(C2-WEEKDAY(C2,3)+2+7*2)>14,C2-WEEKDAY(C2,3)+2+7,C2-WEEKDAY(C2,3)+2+7*2)"}]
["Công thức ô E2"]
[{"$f":"_xlfn.FORMULATEXT(E2)","v":"=Payment_Schedule_VBA(C2,2)"}]
["Công thức ô F2"]
[{"$f":"_xlfn.FORMULATEXT(F2)","v":"=Payment_Schedule_VBA_02(C2,2)"}]