{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","DATEDIF_Year","DATEDIF_Month","DATEDIF Function","LET Function","YEARFRAC_Year","YEARFRAC_Month","YEAR & MONTH Function","Duration","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Dataset","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Start Date","End Date","Year & Month"]
[null,"1990-01-01","2007-10-12",{"$f":"DATEDIF(B5,C5,\"y\")&\" years\"&\", \"&DATEDIF(B5,C5,\"m\")&\" months\"","v":"17 years, 213 months"}]
[null,"1992-04-02","2010-07-28",{"$f":"DATEDIF(B6,C6,\"y\")&\" years\"&\", \"&DATEDIF(B6,C6,\"m\")&\" months\"","v":"18 years, 219 months"}]
[null,"1994-07-03","2018-12-10","24 years, 293 months"]
[null,"1996-10-04","2022-03-11","25 years, 305 months"]

{"sheet":"DATEDIF_Year","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of DATEDIF Function (Year)",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Year",null,null,null,"Start Date","End Date","Year"]
[null,"1990-01-01","2007-10-12",{"$f":"DATEDIF(B5,C5,\"y\")","v":17},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"DATEDIF(B6,C6,\"y\")","v":18},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10",{"$f":"DATEDIF(B7,C7,\"y\")","v":24},null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11",25,null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"DATEDIF_Month","index":2,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of DATEDIF Function (Month)",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Month",null,null,null,"Start Date","End Date","Month"]
[null,"1990-01-01","2007-10-12",{"$f":"DATEDIF(B5,C5,\"m\")","v":213},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"DATEDIF(B6,C6,\"m\")","v":219},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10",293,null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11",305,null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"DATEDIF Function","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of DATEDIF Function",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Year & Month",null,null,null,"Start Date","End Date","Year & Month"]
[null,"1990-01-01","2007-10-12",{"$f":"DATEDIF(B5,C5,\"y\")&\" years\"\n&\", \"&DATEDIF(B5,C5,\"m\")&\" months\"","v":"17 years, 213 months"},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"DATEDIF(B6,C6,\"y\")&\" years\"\n&\", \"&DATEDIF(B6,C6,\"m\")&\" months\"","v":"18 years, 219 months"},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10","24 years, 293 months",null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11","25 years, 305 months",null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"LET Function","index":4,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of LET Function",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Year & Month",null,null,null,"Start Date","End Date","Year & Month"]
[null,"1990-01-01","2007-10-12",{"$f":"_xlfn.LET(_xlpm.start,B5,_xlpm.end,C5,\nDATEDIF(_xlpm.start,_xlpm.end,\"y\")&\" years, \"&\nDATEDIF(_xlpm.start,_xlpm.end,\"m\")&\" months\")","v":"17 years, 213 months"},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"_xlfn.LET(_xlpm.start,B6,_xlpm.end,C6,\nDATEDIF(_xlpm.start,_xlpm.end,\"y\")&\" years, \"&\nDATEDIF(_xlpm.start,_xlpm.end,\"m\")&\" months\")","v":"18 years, 219 months"},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10","24 years, 293 months",null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11","25 years, 305 months",null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"YEARFRAC_Year","index":5,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of YEARFRAC Function",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Year",null,null,null,"Start Date","End Date","Year & Month"]
[null,"1990-01-01","2007-10-12",{"$f":"YEARFRAC(B5,C5)","v":17.780555555555555},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"YEARFRAC(B6,C6)","v":18.322222222222223},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10",24.43611111111111,null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11",{"$f":"YEARFRAC(B8,C8)","v":25.43611111111111},null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"YEARFRAC_Month","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of YEARFRAC Function",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Month",null,null,null,"Start Date","End Date","Month"]
[null,"1990-01-01","2007-10-12",{"$f":"YEARFRAC(B5,C5)*12","v":213.36666666666667},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"YEARFRAC(B6,C6)*12","v":219.86666666666667},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10",293.23333333333335,null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11",305.23333333333335,null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"YEAR & MONTH Function","index":7,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of YEAR & MONTH Function",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Month",null,null,null,"Start Date","End Date","Month"]
[null,"1990-01-01","2007-10-12",{"$f":"(YEAR(C5)-YEAR(B5))*12+\nMONTH(C5)-MONTH(B5)","v":213},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"(YEAR(C6)-YEAR(B6))*12+\nMONTH(C6)-MONTH(B6)","v":219},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10",293,null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11",305,null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"Duration","index":8,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Calculate Duration",null,null,null,null,null,"For Practice"]
[]
[null,"Start Date","End Date","Year & Month",null,null,null,"Start Date","End Date","Year & Month"]
[null,"1990-01-01","2007-10-12",{"$f":"IF(DATEDIF(B5,C5,\"y\"),\nDATEDIF(B5,C5,\"y\")&\" years\",\"\")&\nIF(DATEDIF(B5,C5,\"m\"),\", \"&DATEDIF(B5,C5,\"m\")&\" months\",\"\")","v":"17 years, 213 months"},null,null,null,"1990-01-01","2007-10-12"]
[null,"1992-04-02","2010-07-28",{"$f":"IF(DATEDIF(B6,C6,\"y\"),\nDATEDIF(B6,C6,\"y\")&\" years\",\"\")&\nIF(DATEDIF(B6,C6,\"m\"),\", \"&DATEDIF(B6,C6,\"m\")&\" months\",\"\")","v":"18 years, 219 months"},null,null,null,"1992-04-02","2010-07-28"]
[null,"1994-07-03","2018-12-10","24 years, 293 months",null,null,null,"1994-07-03","2018-12-10"]
[null,"1996-10-04","2022-03-11","25 years, 305 months",null,null,null,"1996-10-04","2022-03-11"]

{"sheet":"VBA","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of VBA Code"]