{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Edate function","Date Function","Fill seires feature","VBA Code"],"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":"Edate function","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of EDATE Function",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Subscription Date","Month","Expiring Date",null,null,null,"Manufactured on","Month","Use by"]
[null,"2022-02-02",3,{"$f":"EDATE(B5,C5)","v":"2022-05-02"},null,null,null,"2022-02-02"]
[null,"2022-03-07",3,{"$f":"EDATE(B6,C6)","v":"2022-06-07"},null,null,null,"2022-03-07"]
[null,"2022-04-29",3,"2022-07-29",null,null,null,"2022-04-29"]
[null,"2022-05-22",3,"2022-08-22",null,null,null,"2022-05-22"]
[null,"2022-06-06",3,"2022-09-06",null,null,null,"2022-06-06"]
[null,"2022-07-21",3,"2022-10-21",null,null,null,"2022-07-21"]
[null,"2022-08-04",3,"2022-11-04",null,null,null,"2022-08-04"]

{"sheet":"Date Function","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of Date Functions",null,null,null,"Practice Yourself"]
[]
[null,"Subscription Date","Month","Expiring Date",null,"Subscription Date","Month","Expiring Date"]
[null,"2022-02-02",3,{"$f":"DATE(YEAR(B5),MONTH(B5)+3,DAY(B5))","v":"2022-05-02"},null,"2022-02-02",3]
[null,"2022-03-07",3,{"$f":"DATE(YEAR(B6),MONTH(B6)+3,DAY(B6))","v":"2022-06-07"},null,"2022-03-07",3]
[null,"2022-04-29",3,"2022-07-29",null,"2022-04-29",3]
[null,"2022-05-22",3,"2022-08-22",null,"2022-05-22",3]
[null,"2022-06-06",3,"2022-09-06",null,"2022-06-06",3]
[null,"2022-07-21",3,"2022-10-21",null,"2022-07-21",3]
[null,"2022-08-04",3,"2022-11-04",null,"2022-08-04",3]

{"sheet":"Fill seires feature","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Fill Series Feature",null,null,"Practice "]
[]
[null,"Order Number","Order Date",null,"Order Number","Order Date"]
[null,1,"2022-04-09",null,1]
[null,2,null,null,2]
[null,3,null,null,3]
[null,4,null,null,4]
[null,5,null,null,5]

{"sheet":"VBA Code","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of VBA Code",null,null,null,"Practice Yourself"]
[]
[null,"Subscription Date","Month","Expiring Date",null,"Subscription Date","Month","Expiring Date"]
[null,"2022-02-02",3,null,null,"2022-02-02",3]
[null,"2022-03-07",3,null,null,"2022-03-07",3]
[null,"2022-04-29",3,null,null,"2022-04-29",3]
[null,"2022-05-22",3,null,null,"2022-05-22",3]
[null,"2022-06-06",3,null,null,"2022-06-06",3]
[null,"2022-07-21",3,null,null,"2022-07-21",3]
[null,"2022-08-04",3,null,null,"2022-08-04",3]