{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset 1","MID Function","DATE Function","Direct Method-1","Direct Method-2","Data Tools","VBA Code"],"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 1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset 1"]
[]
[null,"Name","ID Number"]
[null,"Sam","6905295023021"]
[null,"Adam","5801235800020"]
[null,"Anna","8311034800019"]
[null,"Harry","7104105800018"]
[null,"Tyler","8103115800017"]
[null,"Will","9609124800016"]
[null,"Smith","6306220099015"]
[null,"Julie","8708155053014"]
[null,"Gloria","8906055066013"]
[null,"Mary","9105255800012"]

{"sheet":"MID Function","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using MID Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID Number","Date of Birth","Current Date","Age",null,null,null,null,null,"Name","ID Number","Date of Birth","Current Date","Age"]
[null,"Sam","6905295023021",{"$f":"MID(C5,5,2)&\"/\"&MID(C5,3,2)&\"/\"&MID(C5,1,2)","v":"29/05/69"},{"$f":"TODAY()","v":"2022-06-14"},{"$f":"INT((E5-D5)/365)","v":53},null,null,null,null,null,"Sam","6905295023021"]
[null,"Adam","5801235800020",null,null,null,null,null,null,null,null,"Adam","5801235800020"]
[null,"Anna","8311034800019",null,null,null,null,null,null,null,null,"Anna","8311034800019"]
[null,"Harry","7104105800018",null,null,null,null,null,null,null,null,"Harry","7104105800018"]
[null,"Tyler","8103115800017",null,null,null,null,null,null,null,null,"Tyler","9905145027017"]
[null,"Will","9609124800016",null,null,null,null,null,null,null,null,"Will","9609124800016"]
[null,"Smith","6306220099015",null,null,null,null,null,null,null,null,"Smith","6306220099015"]
[null,"Julie","8708155053014",null,null,null,null,null,null,null,null,"Julie","8708155053014"]
[null,"Gloria","8906055066013",null,null,null,null,null,null,null,null,"Gloria","8906055066013"]
[null,"Mary","9105255800012",null,null,null,null,null,null,null,null,"Mary","9105255800012"]

{"sheet":"DATE Function","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using DATE Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID Number","Date of Birth","Current Date","Age",null,null,null,null,null,"Name","ID Number","Date of Birth","Current Date","Age"]
[null,"Sam","6905295023021",{"$f":"DATE(LEFT(C5,2),MID(C5,3,2),MID(C5,5,2))","v":"1969-05-29"},{"$f":"TODAY()","v":"2022-06-14"},{"$f":"INT((E5-D5)/365)","v":53},null,null,null,null,null,"Sam","6905295023021"]
[null,"Adam","5801235800020",null,null,null,null,null,null,null,null,"Adam","5801235800020"]
[null,"Anna","8311034800019",null,null,null,null,null,null,null,null,"Anna","8311034800019"]
[null,"Harry","7104105800018",null,null,null,null,null,null,null,null,"Harry","7104105800018"]
[null,"Tyler","8103115800017",null,null,null,null,null,null,null,null,"Tyler","8103115800017"]
[null,"Will","9609124800016",null,null,null,null,null,null,null,null,"Will","9609124800016"]
[null,"Smith","6306220099015",null,null,null,null,null,null,null,null,"Smith","6306220099015"]
[null,"Julie","8708155053014",null,null,null,null,null,null,null,null,"Julie","8708155053014"]
[null,"Gloria","8906055066013",null,null,null,null,null,null,null,null,"Gloria","8906055066013"]
[null,"Mary","9105255800012",null,null,null,null,null,null,null,null,"Mary","9105255800012"]

{"sheet":"Direct Method-1","index":3,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using DATEDIF Function with IF Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID Number","Age",null,null,null,null,null,null,null,"Name","ID Number","Age"]
[null,"Sam","6905295023021",{"$f":"DATEDIF(DATE(IF(LEFT(C5,2)>TEXT(TODAY(),\n\"YY\"),\"19\"&LEFT(C5,2),\"20\"&LEFT(C5,2)),\nMID(C5,3,2),MID(C5,5,2)),TODAY(),\"y\")","v":53},null,null,null,null,null,null,null,"Sam","6905295023021"]
[null,"Adam","5801235800020",null,null,null,null,null,null,null,null,"Adam","5801235800020"]
[null,"Anna","8311034800019",null,null,null,null,null,null,null,null,"Anna","8311034800019"]
[null,"Harry","7104105800018",null,null,null,null,null,null,null,null,"Harry","7104105800018"]
[null,"Tyler","8103115800017",null,null,null,null,null,null,null,null,"Tyler","8103115800017"]
[null,"Will","9609124800016",null,null,null,null,null,null,null,null,"Will","9609124800016"]
[null,"Smith","6306220099015",null,null,null,null,null,null,null,null,"Smith","6306220099015"]
[null,"Julie","8708155053014",null,null,null,null,null,null,null,null,"Julie","8708155053014"]
[null,"Gloria","8906055066013",null,null,null,null,null,null,null,null,"Gloria","8906055066013"]
[null,"Mary","9105255800012",null,null,null,null,null,null,null,null,"Mary","9105255800012"]

{"sheet":"Direct Method-2","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using DATEDIF Function with DATE Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID Number","Age",null,null,null,null,null,null,null,"Name","ID Number","Age"]
[null,"Sam","6905295023021",{"$f":"DATEDIF(DATE(MID(C5,1,2),\nMID(C5,3,2),MID(C5,5,2)),TODAY(),\"y\")","v":53},null,null,null,null,null,null,null,"Sam","6905295023021"]
[null,"Adam","5801235800020",null,null,null,null,null,null,null,null,"Adam","5801235800020"]
[null,"Anna","8311034800019",null,null,null,null,null,null,null,null,"Anna","8311034800019"]
[null,"Harry","7104105800018",null,null,null,null,null,null,null,null,"Harry","7104105800018"]
[null,"Tyler","8103115800017",null,null,null,null,null,null,null,null,"Tyler","8103115800017"]
[null,"Will","9609124800016",null,null,null,null,null,null,null,null,"Will","9609124800016"]
[null,"Smith","6306220099015",null,null,null,null,null,null,null,null,"Smith","6306220099015"]
[null,"Julie","8708155053014",null,null,null,null,null,null,null,null,"Julie","8708155053014"]
[null,"Gloria","8906055066013",null,null,null,null,null,null,null,null,"Gloria","8906055066013"]
[null,"Mary","9105255800012",null,null,null,null,null,null,null,null,"Mary","9105255800012"]

{"sheet":"Data Tools","index":5,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Data Tools",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID Number","Date of Birth","Current Date","Age",null,null,null,null,null,"Name","ID Number","Date of Birth","Current Date","Age"]
[null,"Sam","6905295023021","1969-05-29",{"$f":"TODAY()","v":"2022-06-14"},{"$f":"INT((E5-D5)/365)","v":53},null,null,null,null,null,"Sam","6905295023021"]
[null,"Adam","5801235800020","1958-01-23",{"$f":"TODAY()","v":"2022-06-14"},null,null,null,null,null,null,"Adam","5801235800020"]
[null,"Anna","8311034800019","1983-11-03","2022-06-14",null,null,null,null,null,null,"Anna","8311034800019"]
[null,"Harry","7104105800018","1971-04-10","2022-06-14",null,null,null,null,null,null,"Harry","7104105800018"]
[null,"Tyler","8103115800017","1981-03-11","2022-06-14",null,null,null,null,null,null,"Tyler","8103115800017"]
[null,"Will","9609124800016","1996-09-12","2022-06-14",null,null,null,null,null,null,"Will","9609124800016"]
[null,"Smith","6306220099015","1963-06-22","2022-06-14",null,null,null,null,null,null,"Smith","6306220099015"]
[null,"Julie","8708155053014","1987-08-15","2022-06-14",null,null,null,null,null,null,"Julie","8708155053014"]
[null,"Gloria","8906055066013","1989-06-05","2022-06-14",null,null,null,null,null,null,"Gloria","8906055066013"]
[null,"Mary","9105255800012","1991-05-25","2022-06-14",null,null,null,null,null,null,"Mary","9105255800012"]

{"sheet":"VBA Code","index":6,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID Number","Date of Birth","Age",null,null,null,null,null,null,"Name","ID Number","Date of Birth","Age"]
[null,"Sam","6905295023021",{"$f":"MID(C5,5,2)&\"/\"&MID(C5,3,2)\n&\"/\"&MID(C5,1,2)","v":"29/05/69"},{"$f":"calculate_age(D5)","v":53},null,null,null,null,null,null,"Sam","6905295023021"]
[null,"Adam","5801235800020",{"$f":"MID(C6,5,2)&\"/\"&MID(C6,3,2)\n&\"/\"&MID(C6,1,2)","v":"23/01/58"},null,null,null,null,null,null,null,"Adam","5801235800020"]
[null,"Anna","8311034800019","03/11/83",null,null,null,null,null,null,null,"Anna","8311034800019"]
[null,"Harry","7104105800018","10/04/71",null,null,null,null,null,null,null,"Harry","7104105800018"]
[null,"Tyler","8103115800017","11/03/81",null,null,null,null,null,null,null,"Tyler","8103115800017"]
[null,"Will","9609124800016","12/09/96",null,null,null,null,null,null,null,"Will","9609124800016"]
[null,"Smith","6306220099015","22/06/63",null,null,null,null,null,null,null,"Smith","6306220099015"]
[null,"Julie","8708155053014","15/08/87",null,null,null,null,null,null,null,"Julie","8708155053014"]
[null,"Gloria","8906055066013","05/06/89",null,null,null,null,null,null,null,"Gloria","8906055066013"]
[null,"Mary","9105255800012","25/05/91",null,null,null,null,null,null,null,"Mary","9105255800012"]