{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","DATEDIF Function","YEARFRAC Function","DATEDIF & Arithmetic Formula","CONCATENATE & DATEDIF Function","TODAY Function","DATEDIF and TODAY Functions","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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Date of Birth and Current Date of Some Emoloyees"]
[]
[null,"Name Of Employee","Date of Birth","Current Time"]
[null,"Jane","1990-01-01","2019-12-30"]
[null,"Peter","1991-01-01","2019-11-30"]
[null,"Austen","1992-01-01","2019-10-30"]
[null,"Agar","1993-01-01","2019-09-30"]
[null,"Milan","1994-01-01","2019-08-30"]
[null,"Jason","1995-01-01","2019-07-30"]
[null,"Sandy","1996-01-01","2019-06-30"]
[null,"Patel","1997-01-01","2018-12-30"]
[null,"Ross","1998-01-01","2018-11-30"]
[null,"Rob","1999-01-01","2018-10-30"]

{"sheet":"DATEDIF Function","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using DATEDIF Function to Calculate Age in Years",null,null,null,null,null,null,null,"Do it by Yourself"]
[]
[null,"Name Of Employee","Date of Birth","Current Time","Age in Years",null,null,null,null,"Name Of Employee","Date of Birth","Current Time","Age in Years"]
[null,"Jane","1990-01-01","2019-12-30",{"$f":"DATEDIF(C5,D5,\"Y\")","v":29},null,null,null,null,"Jane","1990-01-01","2019-12-30"]
[null,"Peter","1991-01-01","2019-11-30",{"$f":"DATEDIF(C6,D6,\"Y\")","v":28},null,null,null,null,"Peter","1991-01-01","2019-11-30"]
[null,"Austen","1992-01-01","2019-10-30",27,null,null,null,null,"Austen","1992-01-01","2019-10-30"]
[null,"Agar","1993-01-01","2019-09-30",26,null,null,null,null,"Agar","1993-01-01","2019-09-30"]
[null,"Milan","1994-01-01","2019-08-30",25,null,null,null,null,"Milan","1994-01-01","2019-08-30"]
[null,"Jason","1995-01-01","2019-07-30",24,null,null,null,null,"Jason","1995-01-01","2019-07-30"]
[null,"Sandy","1996-01-01","2019-06-30",23,null,null,null,null,"Sandy","1996-01-01","2019-06-30"]
[null,"Patel","1997-01-01","2018-12-30",21,null,null,null,null,"Patel","1997-01-01","2018-12-30"]
[null,"Ross","1998-01-01","2018-11-30",20,null,null,null,null,"Ross","1998-01-01","2018-11-30"]
[null,"Rob","1999-01-01","2018-10-30",19,null,null,null,null,"Rob","1999-01-01","2018-10-30"]

{"sheet":"YEARFRAC Function","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Applying YEARFRAC Function to Calculate Age in Fractional Years",null,null,null,null,null,null,null,"Do it by Yourself"]
[]
[null,"Name Of Employee","Date of Birth","Current Time","Age in Fractional Years",null,null,null,null,"Name Of Employee","Date of Birth","Current Time","Age in Fractional Years"]
[null,"Jane","1990-01-01","2019-12-30",{"$f":"YEARFRAC(C5,D5,1)","v":29.994524048553433},null,null,null,null,"Jane","1990-01-01","2019-12-30"]
[null,"Peter","1991-01-01","2019-11-30",{"$f":"YEARFRAC(C6,D6,1)","v":28.912386706948642},null,null,null,null,"Peter","1991-01-01","2019-11-30"]
[null,"Austen","1992-01-01","2019-10-30",27.827515400410679,null,null,null,null,"Austen","1992-01-01","2019-10-30"]
[null,"Agar","1993-01-01","2019-09-30",26.745360511104352,null,null,null,null,"Agar","1993-01-01","2019-09-30"]
[null,"Milan","1994-01-01","2019-08-30",25.660488626790229,null,null,null,null,"Milan","1994-01-01","2019-08-30"]
[null,"Jason","1995-01-01","2019-07-30",24.575621509144671,null,null,null,null,"Jason","1995-01-01","2019-07-30"]
[null,"Sandy","1996-01-01","2019-06-30",23.493497604380561,null,null,null,null,"Sandy","1996-01-01","2019-06-30"]
[null,"Patel","1997-01-01","2018-12-30",21.994523957685125,null,null,null,null,"Patel","1997-01-01","2018-12-30"]
[null,"Ross","1998-01-01","2018-11-30",20.91238591916558,null,null,null,null,"Ross","1998-01-01","2018-11-30"]
[null,"Rob","1999-01-01","2018-10-30",19.827515400410679,null,null,null,null,"Rob","1999-01-01","2018-10-30"]

{"sheet":"DATEDIF & Arithmetic Formula","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,11]]}
[]
[null,"DATEDIF and Arithmetic Formula to Calculate Complete & Actual Months",null,null,null,null,null,null,"Do it by Yourself"]
[]
[null,"Name Of Employee","Date of Birth","Current Time","Age in Complete Months","Age in Actual Months",null,null,"Name Of Employee","Date of Birth","Current Time","Age in Complete Months","Age in Actual Months"]
[null,"Jane","1990-01-01","2019-12-30",{"$f":"DATEDIF(C5,D5,\"M\")","v":359},{"$f":"+(D5-C5)/30","v":365.16666666666669},null,null,"Jane","1990-01-01","2019-12-30"]
[null,"Peter","1991-01-01","2019-11-30",{"$f":"DATEDIF(C6,D6,\"M\")","v":346},{"$f":"+(D6-C6)/30","v":352},null,null,"Peter","1991-01-01","2019-11-30"]
[null,"Austen","1992-01-01","2019-10-30",333,338.8,null,null,"Austen","1992-01-01","2019-10-30"]
[null,"Agar","1993-01-01","2019-09-30",320,325.60000000000002,null,null,"Agar","1993-01-01","2019-09-30"]
[null,"Milan","1994-01-01","2019-08-30",307,312.39999999999998,null,null,"Milan","1994-01-01","2019-08-30"]
[null,"Jason","1995-01-01","2019-07-30",294,299.2,null,null,"Jason","1995-01-01","2019-07-30"]
[null,"Sandy","1996-01-01","2019-06-30",281,286.03333333333336,null,null,"Sandy","1996-01-01","2019-06-30"]
[null,"Patel","1997-01-01","2018-12-30",263,267.76666666666665,null,null,"Patel","1997-01-01","2018-12-30"]
[null,"Ross","1998-01-01","2018-11-30",250,254.6,null,null,"Ross","1998-01-01","2018-11-30"]
[null,"Rob","1999-01-01","2018-10-30",237,241.4,null,null,"Rob","1999-01-01","2018-10-30"]

{"sheet":"CONCATENATE & DATEDIF Function","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Applying CONCATENATE & DATEDIF Function to Calculate Age in Years, Months & Date",null,null,null,null,"Do It by Yourself"]
[]
[null,"Name Of Employee","Date of Birth","Current Time","Age in Y, M, D",null,"Name Of Employee","Date of Birth","Current Time","Age in Y, M, D"]
[null,"Jane","1990-01-01","2019-12-30",{"$f":"CONCATENATE(DATEDIF(C5,D5,\"Y\"),\" Years \", DATEDIF(C5,D5,\"YM\"),\" Months and \", DATEDIF(C5,D5,\"MD\"),\" Days \")","v":"29 Years 11 Months and 29 Days "},null,"Jane","1990-01-01","2019-12-30"]
[null,"Peter","1991-01-01","2019-11-30",{"$f":"CONCATENATE(DATEDIF(C6,D6,\"Y\"),\" Years \", DATEDIF(C6,D6,\"YM\"),\" Months and \", DATEDIF(C6,D6,\"MD\"),\" Days \")","v":"28 Years 10 Months and 29 Days "},null,"Peter","1991-01-01","2019-11-30"]
[null,"Austen","1992-01-01","2019-10-30","27 Years 9 Months and 29 Days ",null,"Austen","1992-01-01","2019-10-30"]
[null,"Agar","1993-01-01","2019-09-30","26 Years 8 Months and 29 Days ",null,"Agar","1993-01-01","2019-09-30"]
[null,"Milan","1994-01-01","2019-08-30","25 Years 7 Months and 29 Days ",null,"Milan","1994-01-01","2019-08-30"]
[null,"Jason","1995-01-01","2019-07-30","24 Years 6 Months and 29 Days ",null,"Jason","1995-01-01","2019-07-30"]
[null,"Sandy","1996-01-01","2019-06-30","23 Years 5 Months and 29 Days ",null,"Sandy","1996-01-01","2019-06-30"]
[null,"Patel","1997-01-01","2018-12-30","21 Years 11 Months and 29 Days ",null,"Patel","1997-01-01","2018-12-30"]
[null,"Ross","1998-01-01","2018-11-30","20 Years 10 Months and 29 Days ",null,"Ross","1998-01-01","2018-11-30"]
[null,"Rob","1999-01-01","2018-10-30","19 Years 9 Months and 29 Days ",null,"Rob","1999-01-01","2018-10-30"]

{"sheet":"TODAY Function","index":5,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Using TODAY() Function to Calculate Age Based on Current Time",null,null,null,null,null,"Do It by Yourself"]
[]
[null,"Name Of Employee","Date of Birth","Current Time","Age in Years",null,null,"Name Of Employee","Date of Birth","Current Time","Age in Years"]
[null,"Jane","1990-01-01",{"$f":"TODAY()","v":"2022-06-19"},{"$f":"DATEDIF(C5,D5,\"Y\")","v":32},null,null,"Jane","1990-01-01"]
[null,"Peter","1991-01-01",{"$f":"TODAY()","v":"2022-06-19"},{"$f":"DATEDIF(C6,D6,\"Y\")","v":31},null,null,"Peter","1991-01-01"]
[null,"Austen","1992-01-01","2022-06-19",30,null,null,"Austen","1992-01-01"]
[null,"Agar","1993-01-01","2022-06-19",29,null,null,"Agar","1993-01-01"]
[null,"Milan","1994-01-01","2022-06-19",28,null,null,"Milan","1994-01-01"]
[null,"Jason","1995-01-01","2022-06-19",27,null,null,"Jason","1995-01-01"]
[null,"Sandy","1996-01-01","2022-06-19",26,null,null,"Sandy","1996-01-01"]
[null,"Patel","1997-01-01","2022-06-19",25,null,null,"Patel","1997-01-01"]
[null,"Ross","1998-01-01","2022-06-19",24,null,null,"Ross","1998-01-01"]
[null,"Rob","1999-01-01","2022-06-19",23,null,null,"Rob","1999-01-01"]

{"sheet":"DATEDIF and TODAY Functions","index":6,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Using DATEDIF and TODAY Functions to Calculate Age Based on Current Time",null,null,null,null,"Do It by Yourself"]
[]
[null,"Name Of Employee","Date of Birth","Age in Years",null,null,"Name Of Employee","Date of Birth","Age in Years"]
[null,"Jane","1990-01-01",{"$f":"DATEDIF(C5,TODAY(),\"y\")","v":32},null,null,"Jane","1990-01-01"]
[null,"Peter","1991-01-01",{"$f":"DATEDIF(C6,TODAY(),\"y\")","v":31},null,null,"Peter","1991-01-01"]
[null,"Austen","1992-01-01",30,null,null,"Austen","1992-01-01"]
[null,"Agar","1993-01-01",29,null,null,"Agar","1993-01-01"]
[null,"Milan","1994-01-01",28,null,null,"Milan","1994-01-01"]
[null,"Jason","1995-01-01",27,null,null,"Jason","1995-01-01"]
[null,"Sandy","1996-01-01",26,null,null,"Sandy","1996-01-01"]
[null,"Patel","1997-01-01",25,null,null,"Patel","1997-01-01"]
[null,"Ross","1998-01-01",24,null,null,"Ross","1998-01-01"]
[null,"Rob","1999-01-01",23,null,null,"Rob","1999-01-01"]

{"sheet":"VBA","index":7,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Utilizing VBA",null,null,null,null,null,"Do It by Yourself"]
[]
[null,"Name Of Employee","Date of Birth","Current Time","Age in Complete Years",null,null,"Name Of Employee","Date of Birth","Current Time","Age in Complete Years"]
[null,"Jane","1990-01-01","2019-12-30",{"$f":"DATEDIF(C5,D5,\"y\")","v":29},null,null,"Jane","1990-01-01","2019-12-30"]
[null,"Peter","1991-01-01","2019-11-30",28,null,null,"Peter","1991-01-01","2019-11-30"]
[null,"Austen","1992-01-01","2019-10-30",27,null,null,"Austen","1992-01-01","2019-10-30"]
[null,"Agar","1993-01-01","2019-09-30",26,null,null,"Agar","1993-01-01","2019-09-30"]
[null,"Milan","1994-01-01","2019-08-30",25,null,null,"Milan","1994-01-01","2019-08-30"]
[null,"Jason","1995-01-01","2019-07-30",24,null,null,"Jason","1995-01-01","2019-07-30"]
[null,"Sandy","1996-01-01","2019-06-30",23,null,null,"Sandy","1996-01-01","2019-06-30"]
[null,"Patel","1997-01-01","2018-12-30",21,null,null,"Patel","1997-01-01","2018-12-30"]
[null,"Ross","1998-01-01","2018-11-30",20,null,null,"Ross","1998-01-01","2018-11-30"]
[null,"Rob","1999-01-01","2018-10-30",19,null,null,"Rob","1999-01-01","2018-10-30"]