{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Today","YEAR","YEARFRAC","DATEDIF","DATEDIF and DATE","DATEDIF & CONCATENATE","DATEDIF & IF","VBA"],"not_rendered":{"charts":0,"images":0,"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":"Dataset","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Calculating Age on a Specific Date"]
[]
[null,"Name","Date of Birth","Specific Date","Age(Fraction)","Age(Years)"]
[null,"Lily","1974-10-05","2000-05-10"]
[null,"olivia","1990-12-25","2015-09-25"]
[null,"Madison","1956-07-20","2010-08-20"]
[null,"Jessica","1999-11-14","2020-05-30"]
[null,"Scarlett","2000-09-12","2023-12-15"]
[null,"Hannah","1989-03-05","2019-06-09"]
[null,"Phoebe","1993-09-16","2030-10-10"]
[null,"Amanda","1960-11-29","1990-12-19"]

{"sheet":"Today","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,9,2,12]]}
[]
[]
[null,"Calculate Age with TODAY Formula and INT Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Age(Fraction)","Age(year)",null,null,null,null,"Name","Date of Birth","Age(Fraction)","Age(year)"]
[null,"Lily","1974-10-05",{"$f":"(TODAY()-C6)/365","v":48.153424657534245},{"$f":"INT((TODAY()-C6)/365)","v":48},null,null,null,null,"Lily","1974-10-05"]
[null,"olivia","1990-12-25",{"$f":"(TODAY()-C7)/365","v":31.920547945205481},{"$f":"INT((TODAY()-C7)/365)","v":31},null,null,null,null,"olivia","1990-12-25"]
[null,"Madison","1956-07-20",66.37534246575342,66,null,null,null,null,"Madison","1956-07-20"]
[null,"Jessica","1999-11-14",23.027397260273972,23,null,null,null,null,"Jessica","1999-11-14"]
[null,"Scarlett","2000-09-12",22.197260273972603,22,null,null,null,null,"Scarlett","2000-09-12"]
[null,"Hannah","1989-03-05",33.728767123287675,33,null,null,null,null,"Hannah","1989-03-05"]
[null,"Phoebe","1993-09-16",29.19178082191781,29,null,null,null,null,"Phoebe","1993-09-16"]
[null,"Amanda","1960-11-29",62.010958904109586,62,null,null,null,null,"Amanda","1960-11-29"]

{"sheet":"YEAR","index":2,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,9,2,13]]}
[null,"`"]
[]
[null,"Calculate Age with YEAR Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Specific Date","Age To Date(Year)","Age(Year)",null,null,null,"Name","Date of Birth","Specific Date","Age To Date(Year)","Age(Year)"]
[null,"Lily","1974-10-05","2000-05-10",{"$f":"(YEAR(NOW())-YEAR(C6))","v":48},{"$f":"YEAR(D6)-YEAR(C6)","v":26},null,null,null,"Lily","1974-10-05","2000-05-10"]
[null,"olivia","1990-12-25","2015-09-25",{"$f":"(YEAR(NOW())-YEAR(C7))","v":32},{"$f":"YEAR(D7)-YEAR(C7)","v":25},null,null,null,"olivia","1990-12-25","2015-09-25"]
[null,"Madison","1956-07-20","2010-08-20",66,54,null,null,null,"Madison","1956-07-20","2010-08-20"]
[null,"Jessica","1999-11-14","2020-05-30",23,21,null,null,null,"Jessica","1999-11-14","2020-05-30"]
[null,"Scarlett","2000-09-12","2023-12-15",22,23,null,null,null,"Scarlett","2000-09-12","2023-12-15"]
[null,"Hannah","1989-03-05","2019-06-09",33,30,null,null,null,"Hannah","1989-03-05","2019-06-09"]
[null,"Phoebe","1993-09-16","2030-10-10",29,37,null,null,null,"Phoebe","1993-09-16","2030-10-10"]
[null,"Amanda","1960-11-29","1990-12-19",62,30,null,null,null,"Amanda","1960-11-29","1990-12-19"]

{"sheet":"YEARFRAC","index":3,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,15]]}
[]
[]
[null,"Calculate Age with YEARFRAC and ROUNDDOWN Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Specific Date","Age to Date(Fraction)","Age to Date(Year)","Age(Year)",null,null,null,"Name","Date of Birth","Specific Date","Age to Date(Fraction)","Age to Date(Year)","Age(Year)"]
[null,"Lily","1974-10-05","2000-05-10",{"$f":"YEARFRAC(C6,TODAY(),1)","v":48.121137620830304},{"$f":"ROUNDDOWN(YEARFRAC(C6,TODAY(),1),0)","v":48},{"$f":"ROUNDDOWN(YEARFRAC(C6,D6,1),0)","v":25},null,null,null,"Lily","1974-10-05","2000-05-10"]
[null,"olivia","1990-12-25","2015-09-25",{"$f":"YEARFRAC(C7,TODAY(),1)","v":31.899361154899193},{"$f":"ROUNDDOWN(YEARFRAC(C7,TODAY(),1),0)","v":31},{"$f":"ROUNDDOWN(YEARFRAC(C7,D7,1),0)","v":24},null,null,null,"olivia","1990-12-25","2015-09-25"]
[null,"Madison","1956-07-20","2010-08-20",66.329233409610993,66,54,null,null,null,"Madison","1956-07-20","2010-08-20"]
[null,"Jessica","1999-11-14","2020-05-30",23.01163586584531,23,20,null,null,null,"Jessica","1999-11-14","2020-05-30"]
[null,"Scarlett","2000-09-12","2023-12-15",22.181406975360076,22,23,null,null,null,"Scarlett","2000-09-12","2023-12-15"]
[null,"Hannah","1989-03-05","2019-06-09",33.707038170397809,33,30,null,null,null,"Hannah","1989-03-05","2019-06-09"]
[null,"Phoebe","1993-09-16","2030-10-10",29.173131331568857,29,37,null,null,null,"Phoebe","1993-09-16","2030-10-10"]
[null,"Amanda","1960-11-29","1990-12-19",61.967841467124416,61,30,null,null,null,"Amanda","1960-11-29","1990-12-19"]

{"sheet":"DATEDIF","index":4,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,9,2,14]]}
[]
[]
[null,"Calculate Age with DATEDIF Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Specific Date","Age(year)","Age(Month)","Age(month)",null,null,"Name","Date of Birth","Specific Date","Age(year)","Age(Month)","Age(month)"]
[null,"Lily","1974-10-05","2000-05-10",{"$f":"DATEDIF(C6,D6,\"y\")","v":25},{"$f":"DATEDIF(C6,D6,\"m\")","v":307},{"$f":"DATEDIF(C6,D6,\"ym\")","v":7},null,null,"Lily","1974-10-05","2000-05-10"]
[null,"olivia","1990-12-25","2015-09-25",{"$f":"DATEDIF(C7,D7,\"y\")","v":24},{"$f":"DATEDIF(C7,D7,\"m\")","v":297},{"$f":"DATEDIF(C7,D7,\"ym\")","v":9},null,null,"olivia","1990-12-25","2015-09-25"]
[null,"Madison","1956-07-20","2010-08-20",54,649,1,null,null,"Madison","1956-07-20","2010-08-20"]
[null,"Jessica","1999-11-14","2020-05-30",20,246,6,null,null,"Jessica","1999-11-14","2020-05-30"]
[null,"Scarlett","2000-09-12","2023-12-15",23,279,3,null,null,"Scarlett","2000-09-12","2023-12-15"]
[null,"Hannah","1989-03-05","2019-06-09",30,363,3,null,null,"Hannah","1989-03-05","2019-06-09"]
[null,"Phoebe","1993-09-16","2030-10-10",37,444,0,null,null,"Phoebe","1993-09-16","2030-10-10"]
[null,"Amanda","1960-11-29","1990-12-19",30,360,0,null,null,"Amanda","1960-11-29","1990-12-19"]

{"sheet":"DATEDIF and DATE","index":5,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,7],[2,10,2,16],[4,2,4,4],[4,1,5,1],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,11,4,13],[4,10,5,10],[4,14,5,14],[4,15,5,15],[4,16,5,16]]}
[]
[]
[null,"Calculate Age with DATEDIF and DATE Function Showing Years,Months and Days",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth",null,null,"Specific Date","Age(Year)","Age",null,null,"Name","Date of Birth",null,null,"Specific Date","Age(Year)","Age"]
[null,null,"Year","Month","Day",null,null,null,null,null,null,"Year","Month","Day"]
[null,"Lily",1974,10,5,"2000-05-10",{"$f":"DATEDIF(DATE(C7,D7,E7),F7,\"y\")","v":25},{"$f":"DATEDIF(DATE(C7,D7,E7),F7,\"Y\") &\" Years \" & DATEDIF(DATE(C7,D7,E7),F7,\"YM\") & \" Months \" & DATEDIF(DATE(C7,D7,E7),F7,\"MD\") & \" Days\"","v":"25 Years 7 Months 5 Days"},null,null,"Lily",1974,10,5,"2000-05-10"]
[null,"olivia",1990,12,25,"2015-09-25",{"$f":"DATEDIF(DATE(C8,D8,E8),F8,\"y\")","v":24},{"$f":"DATEDIF(DATE(C8,D8,E8),F8,\"Y\") &\" Years \" & DATEDIF(DATE(C8,D8,E8),F8,\"YM\") & \" Months \" & DATEDIF(DATE(C8,D8,E8),F8,\"MD\") & \" Days\"","v":"24 Years 9 Months 0 Days"},null,null,"olivia",1990,12,25,"2015-09-25"]
[null,"Madison",1956,7,20,"2010-08-20",54,"54 Years 1 Months 0 Days",null,null,"Madison",1956,7,20,"2010-08-20"]
[null,"Jessica",1999,11,14,"2020-05-30",20,"20 Years 6 Months 16 Days",null,null,"Jessica",1999,11,14,"2020-05-30"]
[null,"Scarlett",2000,9,12,"2023-12-15",23,"23 Years 3 Months 3 Days",null,null,"Scarlett",2000,9,12,"2023-12-15"]
[null,"Hannah",1989,3,5,"2019-06-09",30,"30 Years 3 Months 4 Days",null,null,"Hannah",1989,3,5,"2019-06-09"]
[null,"Phoebe",1993,9,16,"2030-10-10",37,"37 Years 0 Months 24 Days",null,null,"Phoebe",1993,9,16,"2030-10-10"]
[null,"Amanda",1960,11,29,"1990-12-19",30,"30 Years 0 Months 20 Days",null,null,"Amanda",1960,11,29,"1990-12-19"]

{"sheet":"DATEDIF & CONCATENATE","index":6,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,10,2,13]]}
[]
[]
[null,"Calculate Age with DATEDIF Function and CONCATENATE ",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Specific Date","Age",null,null,null,null,null,"Name","Date of Birth","Specific Date","Age"]
[null,"Lily","1974-10-05","2000-05-10",{"$f":"CONCATENATE(DATEDIF(C6,D6,\"Y\"),\" Years \",DATEDIF(C6,D6,\"YM\"),\" Months \",DATEDIF(C6,D6,\"MD\"),\" Days\")","v":"25 Years 7 Months 5 Days"},null,null,null,null,null,"Lily","1974-10-05","2000-05-10"]
[null,"olivia","1990-12-25","2015-09-25",{"$f":"CONCATENATE(DATEDIF(C7,D7,\"Y\"),\" Years \",DATEDIF(C7,D7,\"YM\"),\" Months \",DATEDIF(C7,D7,\"MD\"),\" Days\")","v":"24 Years 9 Months 0 Days"},null,null,null,null,null,"olivia","1990-12-25","2015-09-25"]
[null,"Madison","1956-07-20","2010-08-20","54 Years 1 Months 0 Days",null,null,null,null,null,"Madison","1956-07-20","2010-08-20"]
[null,"Jessica","1999-11-14","2020-05-30","20 Years 6 Months 16 Days",null,null,null,null,null,"Jessica","1999-11-14","2020-05-30"]
[null,"Scarlett","2000-09-12","2023-12-15","23 Years 3 Months 3 Days",null,null,null,null,null,"Scarlett","2000-09-12","2023-12-15"]
[null,"Hannah","1989-03-05","2019-06-09","30 Years 3 Months 4 Days",null,null,null,null,null,"Hannah","1989-03-05","2019-06-09"]
[null,"Phoebe","1993-09-16","2030-10-10","37 Years 0 Months 24 Days",null,null,null,null,null,"Phoebe","1993-09-16","2030-10-10"]
[null,"Amanda","1960-11-29","1990-12-19","30 Years 0 Months 20 Days",null,null,null,null,null,"Amanda","1960-11-29","1990-12-19"]

{"sheet":"DATEDIF & IF","index":7,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,10,2,13]]}
[]
[]
[null,"Calculate Age with DATEDIF Function and IF STATEMENT",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Specific Date","Age",null,null,null,null,null,"Name","Date of Birth","Specific Date","Age"]
[null,"Lily","1974-10-05","2000-05-10",{"$f":"IF(DATEDIF(C6,D6,\"y\")=0,\"\",DATEDIF(C6,D6,\"y\")&\" Years \")& IF(DATEDIF(C6,D6,\"ym\")=0,\"\",DATEDIF(C6,D6,\"ym\")&\" Months \")& IF(DATEDIF(C6,D6,\"md\")=0,\"\",DATEDIF(C6,D6,\"md\")&\" days\")","v":"25 Years 7 Months 5 days"},null,null,null,null,null,"Lily","1974-10-05","2000-05-10"]
[null,"olivia","1990-12-25","2015-09-25",{"$f":"IF(DATEDIF(C7,D7,\"y\")=0,\"\",DATEDIF(C7,D7,\"y\")&\" Years \")& IF(DATEDIF(C7,D7,\"ym\")=0,\"\",DATEDIF(C7,D7,\"ym\")&\" Months \")& IF(DATEDIF(C7,D7,\"md\")=0,\"\",DATEDIF(C7,D7,\"md\")&\" days\")","v":"24 Years 9 Months "},null,null,null,null,null,"olivia","1990-12-25","2015-09-25"]
[null,"Madison","1956-07-20","2010-08-20","54 Years 1 Months ",null,null,null,null,null,"Madison","1956-07-20","2010-08-20"]
[null,"Jessica","1999-11-14","2020-05-30","20 Years 6 Months 16 days",null,null,null,null,null,"Jessica","1999-11-14","2020-05-30"]
[null,"Scarlett","2000-09-12","2023-12-15","23 Years 3 Months 3 days",null,null,null,null,null,"Scarlett","2000-09-12","2023-12-15"]
[null,"Hannah","1989-03-05","2019-06-09","30 Years 3 Months 4 days",null,null,null,null,null,"Hannah","1989-03-05","2019-06-09"]
[null,"Phoebe","1993-09-16","2030-10-10","37 Years 24 days",null,null,null,null,null,"Phoebe","1993-09-16","2030-10-10"]
[null,"Amanda","1960-11-29","1990-12-19","30 Years 20 days",null,null,null,null,null,"Amanda","1960-11-29","1990-12-19"]

{"sheet":"VBA","index":8,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,9,2,13]]}
[]
[]
[null,"Calculate Age with VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Specific Date","Age to Date(Year)","Age(Year)",null,null,null,"Name","Date of Birth","Specific Date","Age to Date(Year)","Age(Year)"]
[null,"Lily","1974-10-05","2000-05-10",{"$f":"YEAR(TODAY())-YEAR(C6)","v":48},{"$f":"YEAR(D6)-YEAR(C6)","v":26},null,null,null,"Lily","1974-10-05","2000-05-10"]
[null,"olivia","1990-12-25","2015-09-25",32,25,null,null,null,"olivia","1990-12-25","2015-09-25"]
[null,"Madison","1956-07-20","2010-08-20",66,54,null,null,null,"Madison","1956-07-20","2010-08-20"]
[null,"Jessica","1999-11-14","2020-05-30",23,21,null,null,null,"Jessica","1999-11-14","2020-05-30"]
[null,"Scarlett","2000-09-12","2023-12-15",22,23,null,null,null,"Scarlett","2000-09-12","2023-12-15"]
[null,"Hannah","1989-03-05","2019-06-09",33,30,null,null,null,"Hannah","1989-03-05","2019-06-09"]
[null,"Phoebe","1993-09-16","2030-10-10",29,37,null,null,null,"Phoebe","1993-09-16","2030-10-10"]
[null,"Amanda","1960-11-29","1990-12-19",62,30,null,null,null,"Amanda","1960-11-29","1990-12-19"]