{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["EDATE Function","MONTH and DATE Functions","COUNTIFS and EDATE Functions","Fill Series","VBA"],"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":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of EDATE Function",null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Order Date","Process Time ( Months)","Delivery Date",null,"Order ID","Order Date","Process Time ( Months)","Delivery Date"]
[null,1122,"2020-01-02",1,{"$f":"EDATE(C5,D5)","v":"2020-02-02"},null,1122,"2020-01-02",1]
[null,1133,"2020-02-05",4,{"$f":"EDATE(C6,D6)","v":"2020-06-05"},null,1133,"2020-02-05",4]
[null,1144,"2020-04-04",2,"2020-06-04",null,1144,"2020-04-04",2]
[null,1155,"2020-11-02",6,"2021-05-02",null,1155,"2020-11-02",6]
[null,1166,"2020-06-07",1,"2020-07-07",null,1166,"2020-06-07",1]
[null,1177,"2021-02-02",2,"2021-04-02",null,1177,"2021-02-02",2]
[null,1166,"2021-05-08",3,"2021-08-08",null,1166,"2021-05-08",3]
[null,1188,"2020-12-12",4,"2021-04-12",null,1188,"2020-12-12",4]

{"sheet":"MONTH and DATE Functions","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Combination of MONTH and DATE Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Order Date","Process Time ( Months)","Delivery Date",null,"Order ID","Order Date","Process Time ( Months)","Delivery Date"]
[null,1122,"2020-01-02",1,{"$f":"DATE(YEAR(C5),MONTH(C5)+D5,DAY(C5))","v":"2020-02-02"},null,1122,"2020-01-02",1]
[null,1133,"2020-02-05",4,{"$f":"DATE(YEAR(C6),MONTH(C6)+D6,DAY(C6))","v":"2020-06-05"},null,1133,"2020-02-05",4]
[null,1144,"2020-04-04",2,"2020-06-04",null,1144,"2020-04-04",2]
[null,1155,"2020-11-02",6,"2021-05-02",null,1155,"2020-11-02",6]
[null,1166,"2020-06-07",1,"2020-07-07",null,1166,"2020-06-07",1]
[null,1177,"2021-02-02",2,"2021-04-02",null,1177,"2021-02-02",2]
[null,1166,"2021-05-08",3,"2021-08-08",null,1166,"2021-05-08",3]
[null,1188,"2020-12-12",4,"2021-04-12",null,1188,"2020-12-12",4]

{"sheet":"COUNTIFS and EDATE Functions","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Combination of COUNTIFS and EDATE Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Delivery Date",null,"Starting Date ","2020-06-01",null,"Order ID","Delivery Date",null,"Starting Date ","2020-06-01"]
[null,1122,"2020-01-02",null,"End Date ","2020-10-01",null,1122,"2020-01-02",null,"End Date ","2020-10-01"]
[null,1133,"2020-08-05",null,"No of Orders ",{"$f":"COUNTIFS(C5:C12,\">=\"&F4,C5:C12,\"<\"&EDATE(F4,4))","v":3},null,1133,"2020-08-05",null,"No of Orders "]
[null,1144,"2020-04-04",null,null,null,null,1144,"2020-04-04"]
[null,1155,"2020-11-02",null,null,null,null,1155,"2020-11-02"]
[null,1166,"2020-06-07",null,null,null,null,1166,"2020-06-07"]
[null,1177,"2021-02-02",null,null,null,null,1177,"2021-02-02"]
[null,1166,"2020-07-08",null,null,null,null,1166,"2020-07-08"]
[null,1188,"2020-12-12",null,null,null,null,1188,"2020-12-12"]

{"sheet":"Fill Series","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Fill Series",null,null,"Try Yourself"]
[]
[null,"Order ID","Order Date",null,"Order ID","Order Date"]
[null,1122,"2020-01-02",null,1122,"2020-01-02"]
[null,1133,"2020-02-02",null,1133]
[null,1144,"2020-03-02",null,1144]
[null,1155,"2020-04-02",null,1155]
[null,1166,"2020-05-02",null,1166]
[null,1177,"2020-06-02",null,1177]
[null,1166,"2020-07-02",null,1166]
[null,1188,"2020-08-02",null,1188]

{"sheet":"VBA","index":4,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA"]
[]
[null,"Start Date","Adding Months"]
[null,"2020-05-02",3]