{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Contents","Cotents","Eomonth General","Number of days in the month","Last day of the month","Last day of the Previus month","First day of the month","Day of the Year-OP 1","Day of the Year-OP 2","Convert MMMM to Date","Identify MAX and MIN date","Max IF","Split date and Time (Date-Time)","Split date and Time (INT)","Split date and Time (ROUND)","extract day of week from date","extract day from date","extract month from date","extract year from date","Quarter from date Round UP","Quarter from date CHOOSE"],"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["EOMONTH Function"]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Cotents",null,null,null,"Excel Formulas w/Examples"]
[null,"Eomonth General",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Number of days in the month",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Last day of the month"]
[null,"Last day of the Previus month"]
[null,"First day of the month"]
[null,"Day of the Year-OP 1"]
[null,"Day of the Year-OP 2"]
[null,"Convert MMMM to Date"]
[null,"Identify MAX and MIN date"]
[null,"Max IF"]
[null,"Split date and Time (Date-Time)"]
[null,"Split date and Time (INT)"]
[null,"Split date and Time (ROUND)"]
[null,"extract day of week from date"]
[null,"extract day from date"]
[null,"extract month from date"]
[null,"extract year from date"]
[null,"Quarter from date Round UP"]
[null,"Quarter from date CHOOSE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Cotents","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,2,5,2]]}
[]
["#","Sheet Name and Hyperlink","Detail If needed"]
[1,"Emonth General"]
[2,"Number of date in the month"]
[3,"Last day of the month","Same Fucntion But Two Scenario"]
[4,"First day of the month"]
[5,"Day of the Year-OP 1","OP 01"]
[6,"Day of the Year-OP 2","OP 02"]
[7,"Convert MMMM to Date","If Month from Full month form"]
[8,"Identify MAX and MIN date"]
[9,"MAX IF"]
[10,"Split date and Time (Date-Time)","OP 01 Using Date and Time Fucntion"]
[11,"Split date and Time (INT)","OP 02 Using INT fucntion"]
[12,"Split date and Time (ROUND)","OP 03 Using Roundup Function"]
[13,"extract day of week from date","Two Options given to find Full Day and Short day"]
[14,"extract day from date"]
[15,"extract month from date","Three Options given to find Full Month , Short Month and Month as number"]
[16,"extract year from date"]
[17,"Quarter from date Round UP","Quarter OP 01 using Round Up fucntion"]
[18,"Quarter from date CHOOSE","Quarter OP 02 using CHOOSE fucntion"]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Eomonth General","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"EOMONTH",null,"EOMONTH( start_date, months )"]
[null,"Calculates the last day of the month after adding a specified number of months to a date."]
[]
[null,"Date","Months","EOMONTH Result"]
[null,"2020-01-15",0,{"$f":"EOMONTH(B5,C5)","v":"2020-01-31"}]
[null,"2020-01-15",1,{"$f":"EOMONTH(B6,C6)","v":"2020-02-29"}]
[null,"2020-01-15",-1,"2019-12-31"]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Number of days in the month","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","No of Days in the Month"]
[null,"2020-01-15",{"$f":"DAY(EOMONTH(B3,0))","v":31}]
[]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Last day of the month","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Last day of the Month"]
[null,"2020-01-15",{"$f":"EOMONTH(B3,0)","v":"2020-01-31"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Last day of the Previus month","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Last day of the Month"]
[null,"2020-01-15",{"$f":"EOMONTH(B3,-1)","v":"2019-12-31"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"First day of the month","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","First day of the Month"]
[null,"2020-01-15",{"$f":"EOMONTH(B3,-1)+1","v":"2020-01-01"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Day of the Year-OP 1","index":7,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day of the Year"]
[null,"2020-01-30",{"$f":"B3 - DATE(YEAR(B3),1,1)+1","v":"1900-01-30"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Day of the Year-OP 2","index":8,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day of the Year"]
[null,"2020-01-30",{"$f":"B3 - DATE(YEAR(B3),1,0)","v":"1900-01-30"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Convert MMMM to Date","index":9,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Text Month","1st day of the Month"]
[null,"January",{"$f":"DATE(2020,MONTH(B3&1),1)","v":"2020-01-01"}]
[null,"February",{"$f":"DATE(2020,MONTH(B4&1),1)","v":"2020-02-01"}]
[null,"March","2020-03-01"]
[null,"April","2020-04-01"]
[null,"May","2020-05-01"]
[null,"June","2020-06-01"]
[null,"July","2020-07-01"]
[null,"August","2020-08-01"]
[null,"September","2020-09-01"]
[null,"October","2020-10-01"]
[null,"November","2020-11-01"]
[null,"December","2020-12-01"]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Identify MAX and MIN date","index":10,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date",null,"Maxdate"]
[null,"2020-01-01",null,{"$f":"MAX(B3:B14)","v":"2020-12-15"}]
[null,"2020-12-15"]
[null,"2020-10-09",null,"Mindate"]
[null,"2020-09-02",null,{"$f":"MIN(B3:B14)","v":"2020-01-01"}]
[null,"2020-05-05"]
[null,"2020-06-06"]
[null,"2020-11-15"]
[null,"2020-01-08"]
[null,"2020-12-15"]
[null,"2020-07-03"]
[null,"2020-08-01"]
[null,"2020-03-31"]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Max IF","index":11,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Sale Value",null,"Date","2020-10-09"]
[null,"2020-01-01",50,null,"Max Sale Value",{"$f":"MAX(IF(B3:B14=F2,C3:C14))","v":98}]
[null,"2020-12-15",60]
[null,"2020-10-09",85]
[null,"2020-09-02",94]
[null,"2020-05-05",75]
[null,"2020-06-06",83]
[null,"2020-10-09",98]
[null,"2020-01-08",72]
[null,"2020-10-09",56]
[null,"2020-07-03",76]
[null,"2020-08-01",93]
[null,"2020-03-31",73]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Split date and Time (Date-Time)","index":12,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date & Time","Date","Time"]
[null,"2020-04-14T12:50:35.100",{"$f":"DATE(YEAR(B3),MONTH(B3),DAY(B3))","v":"2020-04-14"},{"$f":"TIME(HOUR(B3),MINUTE(B3),SECOND(B3))","v":"12:50:35"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Split date and Time (INT)","index":13,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date & Time","Date","Time"]
[null,"2020-04-14T12:50:35.100",{"$f":"INT(B3)","v":"2020-04-14"},{"$f":"B3-C3","v":"12:50:35.100"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Split date and Time (ROUND)","index":14,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date & Time","Date","Time"]
[null,"2020-04-14T12:50:35.100",{"$f":"ROUNDDOWN(B3,0)","v":"2020-04-14"},{"$f":"B3-C3","v":"12:50:35.100"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"extract day of week from date","index":15,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day"]
[null,"2020-04-14",{"$f":"TEXT(B3,\"DDDD\")","v":"Tuesday"}]
[null,"2020-12-31",{"$f":"TEXT(B4,\"DDD\")","v":"Thu"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"extract day from date","index":16,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day"]
[null,"2020-04-14",{"$f":"TEXT(B3,\"DD\")","v":"14"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"extract month from date","index":17,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day"]
[null,"2020-04-14",{"$f":"TEXT(B3,\"MMMM\")","v":"April"}]
[null,"2020-12-31",{"$f":"TEXT(B4,\"MMM\")","v":"Dec"}]
[null,"2020-02-07",{"$f":"TEXT(B5,\"MM\")","v":"02"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"extract year from date","index":18,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day"]
[null,"2020-04-14",{"$f":"TEXT(B3,\"YYY\")","v":"2020"}]
[null,"2020-02-07",{"$f":"TEXT(B4,\"YY\")","v":"20"}]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Quarter from date Round UP","index":19,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Quarter","Quarter As detail"]
[null,"2020-01-01",{"$f":"ROUNDUP(MONTH(B3)/3,0)","v":1},{"$f":"\"Quarter \"&ROUNDUP(MONTH(B3)/3,0)","v":"Quarter 1"}]
[null,"2020-12-15",{"$f":"ROUNDUP(MONTH(B4)/3,0)","v":4},{"$f":"\"Quarter \"&ROUNDUP(MONTH(B4)/3,0)","v":"Quarter 4"}]
[null,"2020-08-09",3,{"$f":"\"Quarter \"&ROUNDUP(MONTH(B5)/3,0)","v":"Quarter 3"}]
[null,"2020-05-05",2,"Quarter 2"]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Quarter from date CHOOSE","index":20,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Quarter","Quarter As detail"]
[null,"2020-01-01",{"$f":"CHOOSE(MONTH(B3),1,1,1,2,2,2,3,3,3,4,4,4)","v":1},{"$f":"\"Quarter \"&CHOOSE(MONTH(B3),1,1,1,2,2,2,3,3,3,4,4,4)","v":"Quarter 1"}]
[null,"2020-12-15",{"$f":"CHOOSE(MONTH(B4),1,1,1,2,2,2,3,3,3,4,4,4)","v":4},{"$f":"\"Quarter \"&CHOOSE(MONTH(B4),1,1,1,2,2,2,3,3,3,4,4,4)","v":"Quarter 4"}]
[null,"2020-08-09",{"$f":"CHOOSE(MONTH(B5),1,1,1,2,2,2,3,3,3,4,4,4)","v":3},{"$f":"\"Quarter \"&CHOOSE(MONTH(B5),1,1,1,2,2,2,3,3,3,4,4,4)","v":"Quarter 3"}]
[null,"2020-05-05",2,"Quarter 2"]
[]
[null,"automateexcel.com/functions/eomonth-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]