{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Contents","Introduction EDATE","Add One Month","Add Six Months","Subtract One Month","Subtract Six Months","Add One Month for JAN","Subtract one Months for FEB","Edate EOMONTH"],"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":[]}
["EDATE Function"]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction EDATE",null,null,null,"Excel Formulas w/Examples"]
[null,"Add One Month",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Add Six Months",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Subtract One Month"]
[null,"Subtract Six Months"]
[null,"Add One Month for JAN"]
[null,"Subtract one Months for FEB"]
[null,"Edate EOMONTH"]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Introduction EDATE","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"EDATE",null,"EDATE( start_date, months )"]
[null,"The Excel EDATE function returns a date on the same day of the month"]
[]
[null,"Date","Months","EDATE Result"]
[null,"2020-01-15",0,{"$f":"EDATE(B5,C5)","v":"2020-01-15"}]
[null,"2020-01-15",1,{"$f":"EDATE(B6,C6)","v":"2020-02-15"}]
[null,"2020-01-15",-1,"2019-12-15"]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Add One Month","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","EDATE Result"]
[null,"2020-01-15",{"$f":"EDATE(B3,1)","v":"2020-02-15"}]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Add Six Months","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","EDATE Result"]
[null,"2020-01-15",{"$f":"EDATE(B3,6)","v":"2020-07-15"}]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Subtract One Month","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","EDATE Result"]
[null,"2020-01-15",{"$f":"EDATE(B3,-1)","v":"2019-12-15"}]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Subtract Six Months","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","EDATE Result"]
[null,"2020-01-15",{"$f":"EDATE(B3,-6)","v":"2019-07-15"}]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Add One Month for JAN","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","EDATE Result"]
[null,"2020-01-31",{"$f":"EDATE(B3,1)","v":"2020-02-29"}]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Subtract one Months for FEB","index":7,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","EDATE Result"]
[null,"2020-02-29",{"$f":"EDATE(B3,-1)","v":"2020-01-29"}]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Edate EOMONTH","index":8,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","EOMONTH Result"]
[null,"2020-02-29",{"$f":"EOMONTH(B3,1)","v":"2020-03-31"}]
[]
[null,"automateexcel.com/functions/edate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]