{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TODAY","YEARFRAC","DATEIF","Details","Specific","Sheet5"],"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":"TODAY","index":0,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using TODAY Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Birth Date","Age",null,null,null,null,"Name","Birth Date","Age"]
[null,"Paul","1996-02-12",{"$f":"INT((TODAY()-C5)/365)","v":26},null,null,null,null,"Paul","1996-02-12"]
[null,"Williams","1990-03-30",{"$f":"INT((TODAY()-C6)/365)","v":32},null,null,null,null,"Williams","1990-03-30"]
[null,"Sophia","1995-01-03",27,null,null,null,null,"Sophia","1995-01-03"]
[null,"Jones","1998-04-14",24,null,null,null,null,"Jones","1998-04-14"]
[null,"Smith","1987-08-02",35,null,null,null,null,"Smith","1987-08-02"]
[null,"Marcel","1992-06-25",30,null,null,null,null,"Marcel","1992-06-25"]

{"sheet":"YEARFRAC","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using YEARFRAC Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Birth Date","Age",null,null,null,null,"Name","Birth Date","Age"]
[null,"Paul","1996-02-12",{"$f":"ROUNDDOWN(YEARFRAC(C5, TODAY(), 1), 0)","v":26},null,null,null,null,"Paul","1996-02-12"]
[null,"Williams","1990-03-30",{"$f":"ROUNDDOWN(YEARFRAC(C6, TODAY(), 1), 0)","v":32},null,null,null,null,"Williams","1990-03-30"]
[null,"Sophia","1995-01-03",27,null,null,null,null,"Sophia","1995-01-03"]
[null,"Jones","1998-04-14",24,null,null,null,null,"Jones","1998-04-14"]
[null,"Smith","1987-08-02",35,null,null,null,null,"Smith","1987-08-02"]
[null,"Marcel","1992-06-25",30,null,null,null,null,"Marcel","1992-06-25"]

{"sheet":"DATEIF","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using DATEIF Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Birth Date","Age",null,null,null,null,"Name","Birth Date","Age"]
[null,"Paul","1996-02-12",{"$f":"DATEDIF(C5, TODAY(), \"y\")","v":26},null,null,null,null,"Paul","1996-02-12"]
[null,"Williams","1990-03-30",{"$f":"DATEDIF(C6, TODAY(), \"y\")","v":32},null,null,null,null,"Williams","1990-03-30"]
[null,"Sophia","1995-01-03",27,null,null,null,null,"Sophia","1995-01-03"]
[null,"Jones","1998-04-14",24,null,null,null,null,"Jones","1998-04-14"]
[null,"Smith","1987-08-02",35,null,null,null,null,"Smith","1987-08-02"]
[null,"Marcel","1992-06-25",30,null,null,null,null,"Marcel","1992-06-25"]

{"sheet":"Details","index":3,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Age in Years, Months and Days",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Birth Date","Age",null,null,null,"Name","Birth Date","Age"]
[null,"Paul","1996-02-12",{"$f":"DATEDIF(C5,TODAY(),\"Y\") & \" Years, \" & DATEDIF(C5,TODAY(),\"YM\") & \" Months, \" & DATEDIF(C5,TODAY(),\"MD\") & \" Days\"","v":"26 Years, 7 Months, 28 Days"},null,null,null,"Paul","1996-02-12"]
[null,"Williams","1990-03-30",{"$f":"DATEDIF(C6,TODAY(),\"Y\") & \" Years, \" & DATEDIF(C6,TODAY(),\"YM\") & \" Months, \" & DATEDIF(C6,TODAY(),\"MD\") & \" Days\"","v":"32 Years, 6 Months, 10 Days"},null,null,null,"Williams","1990-03-30"]
[null,"Sophia","1995-01-03","27 Years, 9 Months, 7 Days",null,null,null,"Sophia","1995-01-03"]
[null,"Jones","1998-04-14","24 Years, 5 Months, 26 Days",null,null,null,"Jones","1998-04-14"]
[null,"Smith","1987-08-02","35 Years, 2 Months, 8 Days",null,null,null,"Smith","1987-08-02"]
[null,"Marcel","1992-06-25","30 Years, 3 Months, 15 Days",null,null,null,"Marcel","1992-06-25"]

{"sheet":"Specific","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Finding Age on Specific Date",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Birth Date","Given Date","Age",null,null,null,"Name","Birth Date","Given Date","Age"]
[null,"Paul","1996-02-12","2022-10-10",{"$f":"DATEDIF(C5,D5, \"y\")","v":26},null,null,null,"Paul","1996-02-12","2022-10-10"]
[null,"Williams","1990-03-30","2022-10-11",{"$f":"DATEDIF(C6,D6, \"y\")","v":32},null,null,null,"Williams","1990-03-30","2022-10-11"]
[null,"Sophia","1995-01-03","2022-10-12",27,null,null,null,"Sophia","1995-01-03","2022-10-12"]
[null,"Jones","1998-04-14","2022-10-13",24,null,null,null,"Jones","1998-04-14","2022-10-13"]
[null,"Smith","1987-08-02","2022-10-14",35,null,null,null,"Smith","1987-08-02","2022-10-14"]
[null,"Marcel","1992-06-25","2022-10-15",30,null,null,null,"Marcel","1992-06-25","2022-10-15"]

{"sheet":"Sheet5","index":5,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Birth Date","Age",null,null,null,null,"Name","Birth Date","Age"]
[null,"Paul","1996-02-12",{"$f":"(YEAR(NOW())-YEAR(C5))","v":26},null,null,null,null,"Paul","1996-02-12"]
[null,"Williams","1990-03-30",{"$f":"(YEAR(NOW())-YEAR(C6))","v":32},null,null,null,null,"Williams","1990-03-30"]
[null,"Sophia","1995-01-03",27,null,null,null,null,"Sophia","1995-01-03"]
[null,"Jones","1998-04-14",24,null,null,null,null,"Jones","1998-04-14"]
[null,"Smith","1987-08-02",35,null,null,null,null,"Smith","1987-08-02"]
[null,"Marcel","1992-06-25",30,null,null,null,null,"Marcel","1992-06-25"]