{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Introduction YEARFRAC","Less Than One Year","Whole Year","More than One Year","Different Basis "],"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":[]}
["YEARFRAC Function"]
[null,"automateexcel.com/functions/yearfrac-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction YEARFRAC",null,null,null,"Excel Formulas w/Examples"]
[null,"Less Than One Year",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Whole Year",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"More than One Year"]
[null,"Different Basis "]
[]
[]
[]
[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 YEARFRAC","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"YEARFRAC",null,"=YEARFRAC (start_date, end_date, [basis])"]
[null,"The Excel YEARFRAC function returns a decimal value that represents fractional years between two dates"]
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2020-01-31",{"$f":"YEARFRAC(B5,C5)","v":8.3333333333333329E-2}]
[null,"2020-01-01","2020-07-01",{"$f":"YEARFRAC(B6,C6)","v":0.5}]
[null,"2020-01-01","2020-12-31",{"$f":"YEARFRAC(B7,C7)","v":1}]
[null,"2020-01-01","2019-01-01",{"$f":"YEARFRAC(B8,C8)","v":1}]
[null,"2020-01-01","2015-01-01",5]
[]
[null,"automateexcel.com/functions/yearfrac-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Less Than One Year","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-09-01",{"$f":"YEARFRAC(B3,C3)","v":0.66666666666666663}]
[]
[null,"automateexcel.com/functions/yearfrac-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Whole Year","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","2020-12-31",{"$f":"YEARFRAC(B3,C3)","v":1}]
[]
[null,"automateexcel.com/functions/yearfrac-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"More than One Year","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","2021-05-31",{"$f":"YEARFRAC(B3,C3)","v":1.4166666666666667}]
[]
[null,"automateexcel.com/functions/yearfrac-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Different Basis ","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2020-01-01","2021-05-31",{"$f":"YEARFRAC(B3,C3,0)","v":1.4166666666666667}]
[null,"2020-01-01","2021-05-31",{"$f":"YEARFRAC(B4,C4,1)","v":1.411764705882353}]
[null,"2020-01-01","2021-05-31",{"$f":"YEARFRAC(B5,C5,2)","v":1.4333333333333333}]
[null,"2020-01-01","2021-05-31",{"$f":"YEARFRAC(B6,C6,3)","v":1.4136986301369863}]
[null,"2020-01-01","2021-05-31",{"$f":"YEARFRAC(B7,C7,4)","v":1.413888888888889}]
[]
[null,"automateexcel.com/functions/yearfrac-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]