{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Overview","Basic Usage","Current Month","Previous Month","Number of Days","Monthly Working Days","Monthly Avarage Sales","Monthly Occurrces","Total Monthly Sales","If Date within Next n Months","Payments based on Months","EoMonth VBA","#NUM! Error","#VALUE! Error"],"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":"Overview","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EOMONTH Function"]
[]
[null,"Returns the serial number of the last day of the month before or after a specified number of months"]
[null,"=EOMONTH(start_date, months)"]
[]
[null,"Date","Month","Ouput","Explanation","Formula"]
[null,"2020-01-11",2,{"$f":"EOMONTH(B8,C8)","v":"2020-03-31"},"Last day after 2 months",{"$f":"_xlfn.FORMULATEXT(D8)","v":"=EOMONTH(B8,C8)"}]
[null,"2019-02-15",-2,{"$f":"EOMONTH(B9,C9)","v":"2018-12-31"},"Last day before 2 months",{"$f":"_xlfn.FORMULATEXT(D9)","v":"=EOMONTH(B9,C9)"}]
[null,"2017-04-08",12,"2018-04-30","Last day after 12 months","=EOMONTH(B10,C10)"]
[null,"2018-03-18",-6,"2017-09-30","Last day before 6 months","=EOMONTH(B11,C11)"]
[null,"2021-05-22",18,"2022-11-30","Last day after 18 months","=EOMONTH(B12,C12)"]

{"sheet":"Basic Usage","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Basic Usage of EOMONTH Function"]
[]
[null,"Product","Delivery Date","Output"]
[null,"Mouse and Keyboard","2022-01-11",{"$f":"EOMONTH(C5,0)","v":"2022-01-31"}]
[null,"Monitor","2022-02-15",{"$f":"EOMONTH(C6,0)","v":"2022-02-28"}]
[null,"RAM","2022-03-08","2022-03-31"]
[null,"Hard Drive","2022-04-18","2022-04-30"]
[null,"Speaker","2022-05-22","2022-05-31"]
[null,"Motherboard","2022-06-25","2022-06-30"]
[null,"Processor","2022-07-05","2022-07-31"]
[null,"Graphics Card","2022-08-06","2022-08-31"]
[null,"UPS","2022-09-10","2022-09-30"]

{"sheet":"Current Month","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Finding First and Last Days of the Current Month"]
[]
[null,"Today's Date",{"$f":"TODAY()","v":"2022-12-29"}]
[]
[null,"First Day of Current Month",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2022-12-01"}]
[null,"Last Day of Current Month",{"$f":"EOMONTH(TODAY(),0)","v":"2022-12-31"}]

{"sheet":"Previous Month","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Obtaining First and Last Days of the Previous Month"]
[]
[null,"Today's Date",{"$f":"TODAY()","v":"2022-12-29"}]
[]
[null,"First Day of Previous Month",{"$f":"EOMONTH(C4,-2)+1","v":"2022-11-01"}]
[null,"Last Day of Previous Month",{"$f":"EOMONTH(C4,-1)","v":"2022-11-30"}]

{"sheet":"Number of Days","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Calculating Number of Days in a Month"]
[]
[null,"Today's Date",{"$f":"TODAY()","v":"2022-12-29"}]
[]
[null,"Number of Days",{"$f":"DAY(EOMONTH(C4,0))","v":31}]

{"sheet":"Monthly Working Days","index":5,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,1,12,2],[1,1,1,3]]}
[]
[null,"Returning the Working Days in a Month"]
[]
[null,"Month","Start Date","Working Days"]
[null,"February","2022-02-01",{"$f":"NETWORKDAYS(C5, EOMONTH(C5,0),$B$14:$B$20)","v":19}]
[null,"March","2022-03-01",{"$f":"NETWORKDAYS(C6, EOMONTH(C6,0),$B$14:$B$20)","v":21}]
[null,"April","2022-04-01",21]
[null,"May","2022-05-01",21]
[null,"June","2022-06-01",21]
[null,"July","2022-07-01",20]
[null,"August","2022-08-01",23]
[]
[null,"Holidays"]
[null,"2022-02-01","Presidents Day"]
[null,"2022-03-17","Saint Patricks's Day"]
[null,"2022-03-22","Easter"]
[null,"2022-05-08","Mother's Day"]
[null,"2022-05-30","Memorial Day"]
[null,"2022-06-15","Father's Day"]
[null,"2022-07-04","Independence Day"]

{"sheet":"Monthly Avarage Sales","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Computing Monthly Average Sales"]
[]
[null,"Date","Product","Sales"]
[null,"2022-01-15","Processor",4025]
[null,"2022-01-08","RAM",4767]
[null,"2022-01-18","Hard Drive",4533]
[null,"2022-01-22","Processor",1591]
[null,"2022-01-25","RAM",3660]
[null,"2022-02-05","Processor",2092]
[null,"2022-02-06","Hard Drive",2914]
[null,"2022-02-10","Hard Drive",2652]
[]
[null,"Month","Average Sales"]
[null,"2022-01-01",{"$f":"AVERAGEIFS(D5:D12,B5:B12,\">=\"&B15,B5:B12,\"<=\"&EOMONTH(B15,0),C5:C12,\"RAM\")","v":4213.5}]

{"sheet":"Monthly Occurrces","index":7,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Yielding Number of Monthly Occurrences "]
[]
[null,"Date","Product","Sales"]
[null,"2022-01-15","Processor",4025]
[null,"2022-01-08","RAM",4767]
[null,"2022-02-18","Hard Drive",4533]
[null,"2022-02-22","Processor",1591]
[null,"2022-02-25","RAM",3660]
[null,"2022-03-05","Processor",2092]
[null,"2022-03-06","Hard Drive",2914]
[null,"2022-04-10","Hard Drive",2652]
[]
[null,"Month","Number of Occurrence"]
[null,"2022-02-01",{"$f":"COUNTIF(B5:B12,\">\"&B15)-COUNTIF(B5:B12,\">\"&EOMONTH(B15,0))","v":3}]

{"sheet":"Total Monthly Sales","index":8,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Retrieving Total Monthly Sales"]
[]
[null,"Date","Product","Sales"]
[null,"2022-01-15","Processor",4025]
[null,"2022-01-08","RAM",4767]
[null,"2022-01-18","Hard Drive",4533]
[null,"2022-02-22","Processor",1591]
[null,"2022-02-25","RAM",3660]
[null,"2022-02-05","Processor",2092]
[null,"2022-03-06","Hard Drive",2914]
[null,"2022-03-10","Hard Drive",2652]
[]
[null,"Month","Total Sales"]
[null,"2022-01-01",{"$f":"SUMIFS($D$5:$D$12,$B$5:$B$12,\">=\"&B15,$B$5:$B$12,\"<=\"&EOMONTH(B15,0))","v":13325}]
[null,"2022-02-01",{"$f":"SUMIFS($D$5:$D$12,$B$5:$B$12,\">=\"&B16,$B$5:$B$12,\"<=\"&EOMONTH(B16,0))","v":7343}]
[null,"2022-03-01",5566]

{"sheet":"If Date within Next n Months","index":9,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Checking If Date is Within Next n Months "]
[]
[null,"Duties","Deadline","Status"]
[null,"Approval of Project","2022-08-12",{"$f":"AND(C5>EOMONTH(TODAY(),0),C5<=EOMONTH(TODAY(),4))","v":false}]
[null,"Prepare Questionnaire","2022-09-19",{"$f":"AND(C6>EOMONTH(TODAY(),0),C6<=EOMONTH(TODAY(),4))","v":false}]
[null,"Compose Draft of Questionnaire","2022-11-02",false]
[null,"Perform Survey","2022-11-28",false]
[null,"Analyse Results","2022-12-05",false]
[null,"Devise Draft of Suggestions","2022-12-27",false]
[null,"Assemble Report","2023-02-22",true]
[null,"Forward Report to Management","2023-03-01",true]
[null,"Review Results","2023-03-13",true]
[]
[null,"Today's Date",{"$f":"TODAY()","v":"2022-12-29"}]

{"sheet":"Payments based on Months","index":10,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,6],[1,1,1,6]]}
[]
[null,"Categorizing Payments Based on Months"]
[]
[null,"Deadline","Creditor","Amount","Payment Due In"]
[null,null,null,null,"Less than 1 Month","Between 1-2 Months","More than 2 Months"]
[null,"2023-04-05","Stella",2435,{"$f":"IF(B6-EOMONTH($C$14,0)<=30,D6,\"\")","v":""},{"$f":"IF(AND(B6-EOMONTH($C$14,0)>=31,B6-EOMONTH($C$14,0)<=60),D6,\"\")","v":""},{"$f":"IF(B6-EOMONTH($C$14,0)>=61,D6,\"\")","v":2435}]
[null,"2023-01-12","CONFIDENCE Imports",4025,{"$f":"IF(B7-EOMONTH($C$14,0)<=30,D7,\"\")","v":4025},{"$f":"IF(AND(B7-EOMONTH($C$14,0)>=31,B7-EOMONTH($C$14,0)<=60),D7,\"\")","v":""},{"$f":"IF(B7-EOMONTH($C$14,0)>=61,D7,\"\")","v":""}]
[null,"2023-02-09","M3 Inc.",3660,"",3660,""]
[null,"2023-02-19","Bison Sports",4533,"",4533,""]
[null,"2023-01-23","Warton Finances",3500,3500,"",""]
[null,"2023-03-13","W2 Corporation",7600,"","",7600]
[null,"2023-01-05","Archer Construction",4767,4767,"",""]
[]
[null,"Today's Date",{"$f":"DATE(2022,12,28)","v":"2022-12-28"}]

{"sheet":"EoMonth VBA","index":11,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Determining End Date of a Future Month Using EoMonth in VBA"]
[]
[null,"Product","Delivery Date","Output"]
[null,"Mouse and Keyboard","2022-01-11","2022-07-31"]
[null,"Monitor","2022-02-15","2022-08-31"]
[null,"RAM","2022-03-08","2022-09-30"]
[null,"Hard Drive","2022-04-18","2022-10-31"]
[null,"Speaker","2022-05-22","2022-11-30"]
[null,"Motherboard","2022-06-25","2022-12-31"]
[null,"Processor","2022-07-05","2023-01-31"]
[null,"Graphics Card","2022-08-06","2023-02-28"]
[null,"UPS","2022-09-10","2023-03-31"]

{"sheet":"#NUM! Error","index":12,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"EOMONTH Returning #NUM! Error"]
[]
[null,"Product","Delivery Date","Output"]
[null,"Mouse and Keyboard","2022-12-01",{"$f":"EOMONTH(23-23-22,0)","v":{"$error":"#NUM!"}}]
[null,"Monitor","2022-12-10"]
[null,"RAM","2022-12-10"]
[null,"Hard Drive","2022-12-10"]
[null,"Speaker","2022-12-13"]
[null,"Motherboard","2022-12-14"]
[null,"Processor","2022-12-14"]
[null,"Graphics Card","2022-12-22"]
[null,"UPS","2022-12-23"]

{"sheet":"#VALUE! Error","index":13,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"EOMONTH Returning #VALUE! Error"]
[]
[null,"Product","Delivery Date","Output"]
[null,"Mouse and Keyboard","2022-12-01",{"$f":"EOMONTH(C4,1)","v":{"$error":"#VALUE!"}}]
[null,"Monitor","2022-12-10"]
[null,"RAM","2022-12-10"]
[null,"Hard Drive","2022-12-10"]
[null,"Speaker","2022-12-13"]
[null,"Motherboard","2022-12-14"]
[null,"Processor","2022-12-14"]
[null,"Graphics Card","2022-12-22"]
[null,"UPS","2022-12-23"]