{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Same Date Next Month","DATE, YEAR, MONTH","EOMONTH","Showing Next Month","Next Month Days","Automatic Rolling Months","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":"Dataset","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Reference Date"]
[]
[null,"Actual Date"]
[null,"2021-05-22"]
[null,"2019-01-29"]
[null,"2020-08-31"]
[null,"2020-12-16"]
[null,"2020-01-29"]

{"sheet":"Same Date Next Month","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Excel Formula for Next Month",null,null,null,null,"Do It Yourself"]
[]
[null,"Actual Date","Same Date in Next Month",null,null,null,"Actual Date","Same Date in Next Month"]
[null,"2022-05-22",{"$f":"EDATE(B6, 1)","v":"2022-06-22"},null,null,null,"2021-03-24"]
[null,"2022-07-23",{"$f":"EDATE(B7, 1)","v":"2022-08-23"},null,null,null,"2019-02-28"]
[null,"2022-08-24","2022-09-24",null,null,null,"2020-08-31"]
[null,"2022-03-25","2022-04-25",null,null,null,"2021-12-05"]
[null,"2022-01-26","2022-02-26",null,null,null,"2020-08-13"]

{"sheet":"DATE, YEAR, MONTH","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Excel Formula for Next Month",null,null,null,null,"Do It Yourself"]
[]
[null,"Actual Date","1st Day of Next Month",null,null,null,"Actual Date","1st Day of Next Month"]
[null,"2021-05-22",{"$f":"DATE(YEAR(B6),\nMONTH(B6)+1,1)","v":"2021-06-01"},null,null,null,"2021-03-24"]
[null,"2019-01-29",{"$f":"DATE(YEAR(B7),\nMONTH(B7)+1,1)","v":"2019-02-01"},null,null,null,"2019-02-28"]
[null,"2020-08-31","2020-09-01",null,null,null,"2020-08-31"]
[null,"2020-12-16","2021-01-01",null,null,null,"2021-12-05"]
[null,"2020-01-29","2020-02-01",null,null,null,"2020-08-13"]

{"sheet":"EOMONTH","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Excel Formula for Next Month",null,null,null,null,"Do It Yourself"]
[]
[null,"Actual Date","Last Day of Next Month",null,null,null,"Actual Date","Last Day of Next Month"]
[null,"2021-05-22",{"$f":"EOMONTH(B6,1)","v":"2021-06-30"},null,null,null,"2021-03-24"]
[null,"2019-01-29",null,null,null,null,"2019-02-28"]
[null,"2020-08-31",null,null,null,null,"2020-08-31"]
[null,"2020-12-16",null,null,null,null,"2021-12-05"]
[null,"2020-01-29",null,null,null,null,"2020-08-13"]

{"sheet":"Showing Next Month","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Excel Formula for Next Month",null,null,null,null,"Do It Yourself"]
[]
[null,"Actual Date","Next Month",null,null,null,"Actual Date","Next Month"]
[null,"2021-07-22",{"$f":"TEXT(EOMONTH(\nB6,1),\"mmmm\")","v":"August"},null,null,null,"2021-03-24"]
[null,"2022-06-02",{"$f":"TEXT(EOMONTH(\nB7,1),\"mmmm\")","v":"July"},null,null,null,"2019-02-28"]
[null,"2020-10-31","November",null,null,null,"2020-08-31"]
[null,"2020-12-16","January",null,null,null,"2021-12-05"]
[null,"2020-01-25","February",null,null,null,"2020-08-13"]

{"sheet":"Next Month Days","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Excel Formula for Next Month",null,null,null,null,"Do It Yourself"]
[]
[null,"Actual Date","No. of Days in Next Month",null,null,null,"Actual Date","No. of Days in Next Month"]
[null,"2021-05-22",{"$f":"DAY(DATE(YEAR(B6),\n MONTH(B6) +2, 1) -1)","v":30},null,null,null,"2021-03-24"]
[null,"2019-01-29",{"$f":"DAY(DATE(YEAR(B7),\n MONTH(B7) +2, 1) -1)","v":28},null,null,null,"2019-02-28"]
[null,"2020-08-31",30,null,null,null,"2020-08-31"]
[null,"2020-12-16",31,null,null,null,"2021-12-05"]
[null,"2020-01-29",29,null,null,null,"2020-08-13"]

{"sheet":"Automatic Rolling Months","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel Formula for Next Month"]
[]
[null,"Rolling Months with Same Date"]
[null,"2021-05-22"]
[null,"2021-06-22"]
[null,"2021-07-22"]
[null,"2021-08-22"]
[null,"2021-09-22"]
[null,"2021-10-22"]
[null,"2021-11-22"]
[null,"2021-12-22"]
[null,"2022-01-22"]
[null,"2022-02-22"]

{"sheet":"VBA","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Excel Formula for Next Month"]
[]
[null,"Actual Date","Date of the Next Month"]
[null,"2021-05-22","2021-06-22"]
[null,"2019-01-29","2019-02-28"]
[null,"2020-08-31","2020-09-30"]
[null,"2020-12-16","2021-01-16"]
[null,"2020-01-29","2020-02-29"]