{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset-1","DATEDIF function","YEARFRAC function","Age in Years,Months,Dates","Using VBA code","Dataset-2","Arithmetic Formula","EDATE Function"],"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":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset-1"]
[]
[null,"Name","Date of Birth","Date of Retirement"]
[null,"Adam","1976-10-12","2032-08-12"]
[null,"Layla","1987-12-08","2042-04-15"]
[null,"Chris","1978-02-01","2029-02-01"]
[null,"Tony","1962-01-17","2021-10-23"]
[null,"Emilia","1969-05-29","2025-12-30"]
[null,"Lily","1981-06-10","2032-08-12"]
[null,"Camelia","1976-05-09","2042-04-15"]
[null,"Smith","1982-10-23","2029-02-01"]
[null,"John ","1968-11-04","2021-10-23"]
[null,"Brad","1971-02-08","2025-12-30"]

{"sheet":"DATEDIF function","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using DATEDIF function"]
[]
[null,"Name","Date of Birth","Date of Retirement","Retirement Age"]
[null,"Adam","1976-10-12","2032-08-12",{"$f":"DATEDIF(C5,D5,\"y\")","v":55}]
[null,"Layla","1987-12-08","2042-04-15",{"$f":"DATEDIF(C6,D6,\"y\")","v":54}]
[null,"Chris","1978-02-01","2029-02-01",51]
[null,"Tony","1962-01-17","2021-10-23",59]
[null,"Emilia","1969-05-29","2025-12-30",56]
[null,"Lily","1981-06-10","2032-08-12",51]
[null,"Camelia","1976-05-09","2042-04-15",65]
[null,"Smith","1982-10-23","2029-02-01",46]
[null,"John ","1968-11-04","2021-10-23",52]
[null,"Brad","1971-02-08","2025-12-30",54]

{"sheet":"YEARFRAC function","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing YEARFRAC Function"]
[]
[null,"Name","Date of Birth","Date of Retirement","Retirement Age"]
[null,"Adam","1976-10-12","2032-08-12",{"$f":"ROUNDDOWN(YEARFRAC(C5,D5,1),0)","v":55}]
[null,"Layla","1987-12-08","2042-04-15",{"$f":"ROUNDDOWN(YEARFRAC(C6,D6,1),0)","v":54}]
[null,"Chris","1978-02-01","2029-02-01",51]
[null,"Tony","1962-01-17","2021-10-23",59]
[null,"Emilia","1969-05-29","2025-12-30",56]
[null,"Lily","1981-06-10","2032-08-12",51]
[null,"Camelia","1976-05-09","2042-04-15",65]
[null,"Smith","1982-10-23","2029-02-01",46]
[null,"John ","1968-11-04","2021-10-23",52]
[null,"Brad","1971-02-08","2025-12-30",54]

{"sheet":"Age in Years,Months,Dates","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Retirement Age in Years, Months, Days"]
[]
[null,"Name","Date of Birth","Date of Retirement","Retirement Age"]
[null,"Adam","1976-10-12","2032-08-12",{"$f":"DATEDIF(C5,D5,\"Y\")&\" Years, \"&DATEDIF(C5,D5,\"YM\")&\" Months, \"&DATEDIF(C5,D5,\"MD\")&\" Days\"","v":"55 Years, 10 Months, 0 Days"}]
[null,"Layla","1987-12-08","2042-04-15",{"$f":"DATEDIF(C6,D6,\"Y\")&\" Years, \"&DATEDIF(C6,D6,\"YM\")&\" Months, \"&DATEDIF(C6,D6,\"MD\")&\" Days\"","v":"54 Years, 4 Months, 7 Days"}]
[null,"Chris","1978-02-01","2029-02-01","51 Years, 0 Months, 0 Days"]
[null,"Tony","1962-01-17","2021-10-23","59 Years, 9 Months, 6 Days"]
[null,"Emilia","1969-05-29","2025-12-30","56 Years, 7 Months, 1 Days"]
[null,"Lily","1981-06-10","2032-08-12","51 Years, 2 Months, 2 Days"]
[null,"Camelia","1976-05-09","2042-04-15","65 Years, 11 Months, 6 Days"]
[null,"Smith","1982-10-23","2029-02-01","46 Years, 3 Months, 9 Days"]
[null,"John ","1968-11-04","2021-10-23","52 Years, 11 Months, 19 Days"]
[null,"Brad","1971-02-08","2025-12-30","54 Years, 10 Months, 22 Days"]

{"sheet":"Using VBA code","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Code"]
[]
[null,"Name","Date of Birth","Date of Retirement","Retirement Age"]
[null,"Adam","1976-10-12","2032-08-12",{"$f":"DATEDIF(C5,D5,\"y\")","v":55}]
[null,"Layla","1987-12-08","2042-04-15",{"$f":"DATEDIF(C6,D6,\"y\")","v":54}]
[null,"Chris","1978-02-01","2029-02-01",51]
[null,"Tony","1962-01-17","2021-10-23",59]
[null,"Emilia","1969-05-29","2025-12-30",56]
[null,"Lily","1981-06-10","2032-08-12",51]
[null,"Camelia","1976-05-09","2042-04-15",65]
[null,"Smith","1982-10-23","2029-02-01",46]
[null,"John ","1968-11-04","2021-10-23",52]
[null,"Brad","1971-02-08","2025-12-30",{"$f":"DATEDIF(C14,D14,\"y\")","v":54}]

{"sheet":"Dataset-2","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset-2"]
[]
[null,"Name","Date of Birth","Retirement Age"]
[null,"Adam","1976-10-12",55]
[null,"Layla","1987-12-08",54]
[null,"Chris","1978-02-01",51]
[null,"Tony","1962-01-17",59]
[null,"Emilia","1969-05-29",56]
[null,"Lily","1981-06-10",51]
[null,"Camelia","1976-05-09",65]
[null,"Smith","1982-10-23",46]
[null,"John ","1968-11-04",52]
[null,"Brad","1971-02-08",54]

{"sheet":"Arithmetic Formula","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Arithmetic Formula"]
[]
[null,"Name","Date of Birth","Retirement Age","Date of Retirement"]
[null,"Adam","1976-10-12",55,{"$f":"IF(DAY(C5)=1,DATE(YEAR(C5)+D5,MONTH(C5),0),DATE(YEAR(C5)+D5,MONTH(C5)+1,0))","v":"2031-10-31"}]
[null,"Layla","1987-12-08",54,{"$f":"IF(DAY(C6)=1,DATE(YEAR(C6)+D6,MONTH(C6),0),DATE(YEAR(C6)+D6,MONTH(C6)+1,0))","v":"2041-12-31"}]
[null,"Chris","1978-02-01",51,"2029-01-31"]
[null,"Tony","1962-01-17",59,"2021-01-31"]
[null,"Emilia","1969-05-29",56,"2025-05-31"]
[null,"Lily","1981-06-10",51,"2032-06-30"]
[null,"Camelia","1976-05-09",65,"2041-05-31"]
[null,"Smith","1982-10-23",46,"2028-10-31"]
[null,"John ","1968-11-04",52,"2020-11-30"]
[null,"Brad","1971-02-08",54,"2025-02-28"]

{"sheet":"EDATE Function","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using EDATE Function"]
[]
[null,"Name","Date of Birth","Retirement Age","Date of Retirement"]
[null,"Adam","1976-10-12",55,{"$f":"EDATE(C5,12*D5)","v":"2031-10-12"}]
[null,"Layla","1987-12-08",54,{"$f":"EDATE(C6,12*D6)","v":"2041-12-08"}]
[null,"Chris","1978-02-01",51,"2029-02-01"]
[null,"Tony","1962-01-17",59,"2021-01-17"]
[null,"Emilia","1969-05-29",56,"2025-05-29"]
[null,"Lily","1981-06-10",51,"2032-06-10"]
[null,"Camelia","1976-05-09",65,"2041-05-09"]
[null,"Smith","1982-10-23",46,"2028-10-23"]
[null,"John ","1968-11-04",52,"2020-11-04"]
[null,"Brad","1971-02-08",54,"2025-02-08"]