{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Contents","Introduction DAYS","Days Positive","Days Negative","Days ABS","Days Subtract","Days for 4 months","Days 360 for 4 months","Days From Today","DAYS NETWORKINGDAYS"],"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":[]}
["DAYS Function"]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction DAYS",null,null,null,"Excel Formulas w/Examples"]
[null,"Days Positive",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Days Negative",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Days ABS"]
[null,"Days Subtract"]
[null,"Days for 4 months"]
[null,"Days 360 for 4 months"]
[null,"Days From Today"]
[null,"DAYS NETWORKINGDAYS"]
[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 DAYS","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DAYS ",null,"=DAYS (end_date, start_date)"]
[null,"The Excel DAYS function returns the number of days between two dates."]
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2020-01-31",{"$f":"_xlfn.DAYS(C6,B6)","v":30}]
[null,"2020-01-01","2021-01-01",{"$f":"_xlfn.DAYS(C7,B7)","v":366}]
[null,"2020-01-01","2019-01-01",-365]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Days Positive","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2020-01-31",{"$f":"_xlfn.DAYS(C3,B3)","v":30}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Days Negative","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2019-12-01",{"$f":"_xlfn.DAYS(C3,B3)","v":-31}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Days ABS","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2019-12-01",{"$f":"ABS(_xlfn.DAYS(C3,B3))","v":31}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Days Subtract","index":5,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2020-01-31",{"$f":"C3-B3","v":30}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Days for 4 months","index":6,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2020-05-01",{"$f":"_xlfn.DAYS(C3,B3)","v":121}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Days 360 for 4 months","index":7,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2020-05-01",{"$f":"DAYS360(B3,C3)","v":120}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Days From Today","index":8,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","Result"]
[null,"2020-01-01",{"$f":"_xlfn.DAYS(TODAY(),B3)","v":608}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"DAYS NETWORKINGDAYS","index":9,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2020-01-31",{"$f":"NETWORKDAYS(B3,C3)","v":23}]
[]
[null,"automateexcel.com/functions/days-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]