{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Datedif","MathExpressionInt","MathExpressionRound","YearFunction","IntYearFrac","RoundYearFrac","LetFunction","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":43,"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25"]

{"sheet":"Datedif","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of DATEDIF Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",{"$f":"DATEDIF(C5,B5,\"y\")","v":6},null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",{"$f":"DATEDIF(C6,B6,\"y\")","v":4},null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",4,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",{"$f":"DATEDIF(C10,B10,\"y\")","v":3},null,null,null,null,null,null,"2021-02-19","2017-11-25"]

{"sheet":"MathExpressionInt","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Simple Formula with INT",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",{"$f":"INT((B5-C5)/365)","v":6},null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",{"$f":"INT((B6-C6)/365)","v":4},null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",4,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",3,null,null,null,null,null,null,"2021-02-19","2017-11-25"]

{"sheet":"MathExpressionRound","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Simple Formula with ROUND",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",{"$f":"ROUND((B5-C5)/365,0)","v":6},null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",{"$f":"ROUND((B6-C6)/365,0)","v":4},null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",5,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",3,null,null,null,null,null,null,"2021-02-19","2017-11-25"]

{"sheet":"YearFunction","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of YEAR Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",{"$f":"YEAR(B5)-YEAR(C5)","v":6},null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",{"$f":"YEAR(B6)-YEAR(C6)","v":4},null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",4,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",4,null,null,null,null,null,null,"2021-02-19","2017-11-25"]

{"sheet":"IntYearFrac","index":5,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Combination of INT and YEARFRAC Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",{"$f":"INT(YEARFRAC(C5,B5))","v":6},null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",{"$f":"INT(YEARFRAC(C6,B6))","v":4},null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",4,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",3,null,null,null,null,null,null,"2021-02-19","2017-11-25"]

{"sheet":"RoundYearFrac","index":6,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Combination of ROUND and YEARFRAC Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",{"$f":"ROUND(YEARFRAC(C5,B5),0)","v":6},null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",{"$f":"ROUND(YEARFRAC(C6,B6),0)","v":4},null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",5,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",3,null,null,null,null,null,null,"2021-02-19","2017-11-25"]

{"sheet":"LetFunction","index":7,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Combination of LET and YEAR Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",{"$f":"_xlfn.LET(_xlpm.sDate,YEAR(C5),_xlpm.eDate,\nYEAR(B5),_xlpm.eDate-_xlpm.sDate)","v":6},null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",{"$f":"_xlfn.LET(_xlpm.sDate,YEAR(C6),_xlpm.eDate,\nYEAR(B6),_xlpm.eDate-_xlpm.sDate)","v":4},null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",4,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",4,null,null,null,null,null,null,"2021-02-19","2017-11-25"]

{"sheet":"VBA","index":8,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Date","Second Date","Year Difference",null,null,null,null,null,null,"First Date","Second Date","Year Difference"]
[null,"2022-06-23","2016-05-24",6,null,null,null,null,null,null,"2022-06-23","2016-05-24"]
[null,"2021-09-12","2017-08-23",4,null,null,null,null,null,null,"2021-09-12","2017-08-23"]
[null,"2020-08-24","2018-03-24",2,null,null,null,null,null,null,"2020-08-24","2018-03-24"]
[null,"2019-12-16","2015-04-16",4,null,null,null,null,null,null,"2019-12-16","2015-04-16"]
[null,"2018-11-04","2014-05-18",4,null,null,null,null,null,null,"2018-11-04","2014-05-18"]
[null,"2021-02-19","2017-11-25",4,null,null,null,null,null,null,"2021-02-19","2017-11-25"]