{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Subtraction","YEAR,MONTH,NOW","Different Cells","YEARFRAC","DATEDIF","IF with DATEDIF","Specific Date","Given Age","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":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Birth Dates"]
[]
[null,"Name","Birthday"]
[null,"Robin","1996-08-13"]
[null,"Mary","1988-05-12"]
[null,"Jones","1990-06-09"]
[null,"Susan","1985-12-07"]
[null,"James","1992-09-06"]
[null,"Frank","1999-03-23"]
[null,"Jennifer","1987-08-15"]
[null,"Thomas","1995-07-20"]
[null,"Mark","1986-12-25"]
[null,"Sandra","1990-10-10"]

{"sheet":"Subtraction","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Subtraction"]
[]
[null,"Name","Birthday","Present Age","Age in Complete Years"]
[null,"Robin","1996-08-13",{"$f":"(TODAY()-C5)/365.25","v":25.831622176591377},{"$f":"INT(D5)","v":25}]
[null,"Mary","1988-05-12",{"$f":"(TODAY()-C6)/365.25","v":34.086242299794662},{"$f":"INT(D6)","v":34}]
[null,"Jones","1990-06-09",32.010951403148532,{"$f":"INT(D7)","v":32}]
[null,"Susan","1985-12-07",36.514715947980832,{"$f":"INT(D8)","v":36}]
[null,"James","1992-09-06",29.765913757700204,{"$f":"INT(D9)","v":29}]
[null,"Frank","1999-03-23",23.225188227241617,{"$f":"INT(D10)","v":23}]
[null,"Jennifer","1987-08-15",34.828199863107457,{"$f":"INT(D11)","v":34}]
[null,"Thomas","1995-07-20",26.899383983572896,{"$f":"INT(D12)","v":26}]
[null,"Mark","1986-12-25",35.466119096509239,{"$f":"INT(D13)","v":35}]
[null,"Sandra","1990-10-10",31.674195756331279,{"$f":"INT(D14)","v":31}]

{"sheet":"YEAR,MONTH,NOW","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining IF,YEAR,MONTH,NOW Function"]
[]
[null,"Name","Birthday","Present Age"]
[null,"Robin","1996-08-13",{"$f":"IF(MONTH(NOW())>MONTH(C5),YEAR(NOW())-YEAR(C5)&\"yr \"&MONTH(NOW())-MONTH(C5)&\"mo\",YEAR(NOW())-(YEAR(C5)+1)&\"yr \"&(MONTH(NOW())+12)-MONTH(C5)&\"mo\")","v":"25yr 10mo"}]
[null,"Mary","1988-05-12",{"$f":"IF(MONTH(NOW())>MONTH(C6),YEAR(NOW())-YEAR(C6)&\"yr \"&MONTH(NOW())-MONTH(C6)&\"mo\",YEAR(NOW())-(YEAR(C6)+1)&\"yr \"&(MONTH(NOW())+12)-MONTH(C6)&\"mo\")","v":"34yr 1mo"}]
[null,"Jones","1990-06-09","31yr 12mo"]
[null,"Susan","1985-12-07","36yr 6mo"]
[null,"James","1992-09-06","29yr 9mo"]
[null,"Frank","1999-03-23","23yr 3mo"]
[null,"Jennifer","1987-08-15","34yr 10mo"]
[null,"Thomas","1995-07-20","26yr 11mo"]
[null,"Mark","1986-12-25","35yr 6mo"]
[null,"Sandra","1990-10-10","31yr 8mo"]

{"sheet":"Different Cells","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Calculating Age from Birth Year, Month, Day in Different Cells"]
[]
[null,"Name","Year","Month","Day","Birthday","Present Age"]
[null,"Robin",1996,"August",13,{"$f":"DATE(C5,MONTH(DATEVALUE(D5&\"1\")),E5)","v":"1996-08-13"},{"$f":"DATEDIF(DATE(C5, MONTH(DATEVALUE(D5&\"1\")), E5), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C5, MONTH(DATEVALUE(D5&\"1\")), E5),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C5, MONTH(DATEVALUE(D5&\"1\")), E5), TODAY(), \"md\") & \" Days\"","v":"25 Years, 10 Months, 0 Days"}]
[null,"Mary",1988,"May",12,{"$f":"DATE(C6,MONTH(DATEVALUE(D6&\"1\")),E6)","v":"1988-05-12"},{"$f":"DATEDIF(DATE(C6, MONTH(DATEVALUE(D6&\"1\")), E6), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C6, MONTH(DATEVALUE(D6&\"1\")), E6),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C6, MONTH(DATEVALUE(D6&\"1\")), E6), TODAY(), \"md\") & \" Days\"","v":"34 Years, 1 Months, 1 Days"}]
[null,"Jones",1990,"June",9,"1990-06-09",{"$f":"DATEDIF(DATE(C7, MONTH(DATEVALUE(D7&\"1\")), E7), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C7, MONTH(DATEVALUE(D7&\"1\")), E7),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C7, MONTH(DATEVALUE(D7&\"1\")), E7), TODAY(), \"md\") & \" Days\"","v":"32 Years, 0 Months, 4 Days"}]
[null,"Susan",1985,"December",7,"1985-12-07",{"$f":"DATEDIF(DATE(C8, MONTH(DATEVALUE(D8&\"1\")), E8), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C8, MONTH(DATEVALUE(D8&\"1\")), E8),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C8, MONTH(DATEVALUE(D8&\"1\")), E8), TODAY(), \"md\") & \" Days\"","v":"36 Years, 6 Months, 6 Days"}]
[null,"James",1992,"September",6,"1992-09-06",{"$f":"DATEDIF(DATE(C9, MONTH(DATEVALUE(D9&\"1\")), E9), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C9, MONTH(DATEVALUE(D9&\"1\")), E9),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C9, MONTH(DATEVALUE(D9&\"1\")), E9), TODAY(), \"md\") & \" Days\"","v":"29 Years, 9 Months, 7 Days"}]
[null,"Frank",1999,"March",23,"1999-03-23",{"$f":"DATEDIF(DATE(C10, MONTH(DATEVALUE(D10&\"1\")), E10), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C10, MONTH(DATEVALUE(D10&\"1\")), E10),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C10, MONTH(DATEVALUE(D10&\"1\")), E10), TODAY(), \"md\") & \" Days\"","v":"23 Years, 2 Months, 21 Days"}]
[null,"Jennifer",1987,"August",15,"1987-08-15",{"$f":"DATEDIF(DATE(C11, MONTH(DATEVALUE(D11&\"1\")), E11), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C11, MONTH(DATEVALUE(D11&\"1\")), E11),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C11, MONTH(DATEVALUE(D11&\"1\")), E11), TODAY(), \"md\") & \" Days\"","v":"34 Years, 9 Months, 29 Days"}]
[null,"Thomas",1995,"July",20,"1995-07-20",{"$f":"DATEDIF(DATE(C12, MONTH(DATEVALUE(D12&\"1\")), E12), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C12, MONTH(DATEVALUE(D12&\"1\")), E12),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C12, MONTH(DATEVALUE(D12&\"1\")), E12), TODAY(), \"md\") & \" Days\"","v":"26 Years, 10 Months, 24 Days"}]
[null,"Mark",1986,"December",25,"1986-12-25",{"$f":"DATEDIF(DATE(C13, MONTH(DATEVALUE(D13&\"1\")), E13), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C13, MONTH(DATEVALUE(D13&\"1\")), E13),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C13, MONTH(DATEVALUE(D13&\"1\")), E13), TODAY(), \"md\") & \" Days\"","v":"35 Years, 5 Months, 19 Days"}]
[null,"Sandra",1990,"October",10,"1990-10-10",{"$f":"DATEDIF(DATE(C14, MONTH(DATEVALUE(D14&\"1\")), E14), TODAY(), \"y\") & \" Years, \"& DATEDIF(DATE(C14, MONTH(DATEVALUE(D14&\"1\")), E14),TODAY(), \"ym\") & \" Months, \"&  DATEDIF(DATE(C14, MONTH(DATEVALUE(D14&\"1\")), E14), TODAY(), \"md\") & \" Days\"","v":"31 Years, 8 Months, 3 Days"}]

{"sheet":"YEARFRAC","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Implementing YEARFRAC Function"]
[]
[null,"Name","Birthday","Present Age","Age in Complete Years"]
[null,"Robin","1996-08-13",{"$f":"YEARFRAC(C5,TODAY(),1)","v":25.830967349422025},{"$f":"INT(D5)","v":25}]
[null,"Mary","1988-05-12",{"$f":"YEARFRAC(C6,TODAY(),1)","v":34.085575719649562},{"$f":"INT(D6)","v":34}]
[null,"Jones","1990-06-09",32.011615365469176,{"$f":"INT(D7)","v":32}]
[null,"Susan","1985-12-07",36.516031414367028,{"$f":"INT(D8)","v":36}]
[null,"James","1992-09-06",29.76525655744944,{"$f":"INT(D9)","v":29}]
[null,"Frank","1999-03-23",23.225188227241617,{"$f":"INT(D10)","v":23}]
[null,"Jennifer","1987-08-15",34.828199863107457,{"$f":"INT(D11)","v":34}]
[null,"Thomas","1995-07-20",26.899383983572896,{"$f":"INT(D12)","v":26}]
[null,"Mark","1986-12-25",35.466775196092939,{"$f":"INT(D13)","v":35}]
[null,"Sandra","1990-10-10",31.674852733759231,{"$f":"INT(D14)","v":31}]

{"sheet":"DATEDIF","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adopting DATEDIF Function"]
[]
[null,"Name","Birthday","Present Age"]
[null,"Robin","1996-08-13",{"$f":"DATEDIF(C5,TODAY(),\"Y\") & \" Years, \" & DATEDIF(C5,TODAY(),\"YM\") & \" Months, \" & DATEDIF(C5,TODAY(),\"MD\") & \" Days\"","v":"25 Years, 10 Months, 0 Days"}]
[null,"Mary","1988-05-12",{"$f":"DATEDIF(C6,TODAY(),\"Y\") & \" Years, \" & DATEDIF(C6,TODAY(),\"YM\") & \" Months, \" & DATEDIF(C6,TODAY(),\"MD\") & \" Days\"","v":"34 Years, 1 Months, 1 Days"}]
[null,"Jones","1990-06-09","32 Years, 0 Months, 4 Days"]
[null,"Susan","1985-12-07","36 Years, 6 Months, 6 Days"]
[null,"James","1992-09-06","29 Years, 9 Months, 7 Days"]
[null,"Frank","1999-03-23","23 Years, 2 Months, 21 Days"]
[null,"Jennifer","1987-08-15","34 Years, 9 Months, 29 Days"]
[null,"Thomas","1995-07-20","26 Years, 10 Months, 24 Days"]
[null,"Mark","1986-12-25","35 Years, 5 Months, 19 Days"]
[null,"Sandra","1990-10-10","31 Years, 8 Months, 3 Days"]

{"sheet":"IF with DATEDIF","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining IF with DATEDIF Function"]
[]
[null,"Name","Birthday","Present Age"]
[null,"Robin","1996-08-13",{"$f":"IF(DATEDIF(C5, TODAY(),\"y\")=0,\"\",DATEDIF(C5, TODAY(),\"y\")&\" years, \")& IF(DATEDIF(C5, TODAY(),\"ym\")=0,\"\",DATEDIF(C5, TODAY(),\"ym\")&\" months, \")& IF(DATEDIF(C5, TODAY(),\"md\")=0,\"\",DATEDIF(C5, TODAY(),\"md\")&\" days\")","v":"25 years, 10 months, "}]
[null,"Mary","1988-05-12",{"$f":"IF(DATEDIF(C6, TODAY(),\"y\")=0,\"\",DATEDIF(C6, TODAY(),\"y\")&\" years, \")& IF(DATEDIF(C6, TODAY(),\"ym\")=0,\"\",DATEDIF(C6, TODAY(),\"ym\")&\" months, \")& IF(DATEDIF(C6, TODAY(),\"md\")=0,\"\",DATEDIF(C6, TODAY(),\"md\")&\" days\")","v":"34 years, 1 months, 1 days"}]
[null,"Jones","1990-06-09","32 years, 4 days"]
[null,"Susan","1985-12-07","36 years, 6 months, 6 days"]
[null,"James","1992-09-06","29 years, 9 months, 7 days"]
[null,"Frank","1999-03-23","23 years, 2 months, 21 days"]
[null,"Jennifer","1987-08-15","34 years, 9 months, 29 days"]
[null,"Thomas","1995-07-20","26 years, 10 months, 24 days"]
[null,"Mark","1986-12-25","35 years, 5 months, 19 days"]
[null,"Sandra","1990-10-10","31 years, 8 months, 3 days"]

{"sheet":"Specific Date","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adopting DATEDIF Function"]
[]
[null,"Name","Birthday","Specific Date","Age"]
[null,"Robin","1996-08-13","2010-03-15",{"$f":"DATEDIF(C5, D5,\"Y\") & \" Years, \"& DATEDIF(C5,D5,\"YM\") & \" Months, \"&DATEDIF(C5,D5, \"MD\") & \" Days\"","v":"13 Years, 7 Months, 2 Days"}]
[null,"Mary","1988-05-12","2010-04-16",{"$f":"DATEDIF(C6, D6,\"Y\") & \" Years, \"& DATEDIF(C6,D6,\"YM\") & \" Months, \"&DATEDIF(C6,D6, \"MD\") & \" Days\"","v":"21 Years, 11 Months, 4 Days"}]
[null,"Jones","1990-06-09","2010-05-18",{"$f":"DATEDIF(C7, D7,\"Y\") & \" Years, \"& DATEDIF(C7,D7,\"YM\") & \" Months, \"&DATEDIF(C7,D7, \"MD\") & \" Days\"","v":"19 Years, 11 Months, 9 Days"}]
[null,"Susan","1985-12-07","2010-06-19",{"$f":"DATEDIF(C8, D8,\"Y\") & \" Years, \"& DATEDIF(C8,D8,\"YM\") & \" Months, \"&DATEDIF(C8,D8, \"MD\") & \" Days\"","v":"24 Years, 6 Months, 12 Days"}]
[null,"James","1992-09-06","2010-07-21",{"$f":"DATEDIF(C9, D9,\"Y\") & \" Years, \"& DATEDIF(C9,D9,\"YM\") & \" Months, \"&DATEDIF(C9,D9, \"MD\") & \" Days\"","v":"17 Years, 10 Months, 15 Days"}]
[null,"Frank","1999-03-23","2010-08-22",{"$f":"DATEDIF(C10, D10,\"Y\") & \" Years, \"& DATEDIF(C10,D10,\"YM\") & \" Months, \"&DATEDIF(C10,D10, \"MD\") & \" Days\"","v":"11 Years, 4 Months, 30 Days"}]
[null,"Jennifer","1987-08-15","2010-09-23",{"$f":"DATEDIF(C11, D11,\"Y\") & \" Years, \"& DATEDIF(C11,D11,\"YM\") & \" Months, \"&DATEDIF(C11,D11, \"MD\") & \" Days\"","v":"23 Years, 1 Months, 8 Days"}]
[null,"Thomas","1995-07-20","2010-10-25",{"$f":"DATEDIF(C12, D12,\"Y\") & \" Years, \"& DATEDIF(C12,D12,\"YM\") & \" Months, \"&DATEDIF(C12,D12, \"MD\") & \" Days\"","v":"15 Years, 3 Months, 5 Days"}]
[null,"Mark","1986-12-25","2010-11-26",{"$f":"DATEDIF(C13, D13,\"Y\") & \" Years, \"& DATEDIF(C13,D13,\"YM\") & \" Months, \"&DATEDIF(C13,D13, \"MD\") & \" Days\"","v":"23 Years, 11 Months, 1 Days"}]
[null,"Sandra","1990-10-10","2010-12-28",{"$f":"DATEDIF(C14, D14,\"Y\") & \" Years, \"& DATEDIF(C14,D14,\"YM\") & \" Months, \"&DATEDIF(C14,D14, \"MD\") & \" Days\"","v":"20 Years, 2 Months, 18 Days"}]

{"sheet":"Given Age","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Calculating Date when Someone Reaches a Certain Age"]
[]
[null,"Name","Birthday","Date of Attaining 50 Years Age"]
[null,"Robin","1996-08-13",{"$f":"DATE(YEAR(C5)+50,MONTH(C5),DAY(C5))","v":"2046-08-13"}]
[null,"Mary","1988-05-12",{"$f":"DATE(YEAR(C6)+50,MONTH(C6),DAY(C6))","v":"2038-05-12"}]
[null,"Jones","1990-06-09","2040-06-09"]
[null,"Susan","1985-12-07","2035-12-07"]
[null,"James","1992-09-06","2042-09-06"]
[null,"Frank","1999-03-23","2049-03-23"]
[null,"Jennifer","1987-08-15","2037-08-15"]
[null,"Thomas","1995-07-20","2045-07-20"]
[null,"Mark","1986-12-25","2036-12-25"]
[null,"Sandra","1990-10-10","2040-10-10"]

{"sheet":"VBA","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA"]
[]
[null,"Name","Birthday","Present Age"]
[null,"Robin","1996-08-13",{"$f":"DATEDIF(C5,NOW(),\"y\")","v":25}]
[null,"Mary","1988-05-12",34]
[null,"Jones","1990-06-09",32]
[null,"Susan","1985-12-07",36]
[null,"James","1992-09-06",29]
[null,"Frank","1999-03-23",23]
[null,"Jennifer","1987-08-15",34]
[null,"Thomas","1995-07-20",26]
[null,"Mark","1986-12-25",35]
[null,"Sandra","1990-10-10",31]