{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","MONTH & DAY","TEXT&VALUE","DATE","SORTBY","VBA","Practice"],"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":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"\"XYZ\" Company"]
[]
[null,"Employee Id","Employee Name","Birthday"]
[null,18001,"Jefferson","1990-01-29"]
[null,18002,"Emily","1989-03-06"]
[null,18003,"Sara","1978-01-16"]
[null,18004,"John","1992-05-13"]
[null,18005,"Michael","1991-02-27"]
[null,18006,"Daniel","1995-03-12"]
[null,18007,"Gabriel","1980-05-18"]
[null,18008,"Sheldon","1991-01-10"]
[null,18009,"Lara","1998-02-25"]
[null,18010,"Kate","1992-03-26"]

{"sheet":"MONTH & DAY","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using MONTH and DAY Functions"]
[]
[null,"Employee Id","Employee Name","Birthday","Month","Day"]
[null,18008,"Sheldon","1991-01-10",{"$f":"MONTH(D4)","v":1},{"$f":"DAY(D4)","v":10}]
[null,18003,"Sara","1978-01-16",{"$f":"MONTH(D5)","v":1},{"$f":"DAY(D5)","v":16}]
[null,18001,"Jefferson","1990-01-29",{"$f":"MONTH(D6)","v":1},{"$f":"DAY(D6)","v":29}]
[null,18009,"Lara","1998-02-25",{"$f":"MONTH(D7)","v":2},{"$f":"DAY(D7)","v":25}]
[null,18005,"Michael","1991-02-27",{"$f":"MONTH(D8)","v":2},{"$f":"DAY(D8)","v":27}]
[null,18002,"Emily","1989-03-06",{"$f":"MONTH(D9)","v":3},{"$f":"DAY(D9)","v":6}]
[null,18006,"Daniel","1995-03-12",{"$f":"MONTH(D10)","v":3},{"$f":"DAY(D10)","v":12}]
[null,18010,"Kate","1992-03-26",{"$f":"MONTH(D11)","v":3},{"$f":"DAY(D11)","v":26}]
[null,18004,"John","1992-05-13",{"$f":"MONTH(D12)","v":5},{"$f":"DAY(D12)","v":13}]
[null,18007,"Gabriel","1980-05-18",{"$f":"MONTH(D13)","v":5},{"$f":"DAY(D13)","v":18}]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"TEXT&VALUE","index":2,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using TEXT and VALUE Functions"]
[]
[null,"Employee Id","Employee Name","Birthday","Text","Value"]
[null,18008,"Sheldon","1991-01-10",{"$f":"TEXT(D4,\"mdd\")","v":"110"},{"$f":"VALUE(E4)","v":110}]
[null,18003,"Sara","1978-01-16",{"$f":"TEXT(D5,\"mdd\")","v":"116"},{"$f":"VALUE(E5)","v":116}]
[null,18001,"Jefferson","1990-01-29",{"$f":"TEXT(D6,\"mdd\")","v":"129"},{"$f":"VALUE(E6)","v":129}]
[null,18009,"Lara","1998-02-25",{"$f":"TEXT(D7,\"mdd\")","v":"225"},{"$f":"VALUE(E7)","v":225}]
[null,18005,"Michael","1991-02-27",{"$f":"TEXT(D8,\"mdd\")","v":"227"},{"$f":"VALUE(E8)","v":227}]
[null,18002,"Emily","1989-03-06",{"$f":"TEXT(D9,\"mdd\")","v":"306"},{"$f":"VALUE(E9)","v":306}]
[null,18006,"Daniel","1995-03-12",{"$f":"TEXT(D10,\"mdd\")","v":"312"},{"$f":"VALUE(E10)","v":312}]
[null,18010,"Kate","1992-03-26",{"$f":"TEXT(D11,\"mdd\")","v":"326"},{"$f":"VALUE(E11)","v":326}]
[null,18004,"John","1992-05-13",{"$f":"TEXT(D12,\"mdd\")","v":"513"},{"$f":"VALUE(E12)","v":513}]
[null,18007,"Gabriel","1980-05-18",{"$f":"TEXT(D13,\"mdd\")","v":"518"},{"$f":"VALUE(E13)","v":518}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"DATE","index":3,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using DATE Function"]
[]
[null,"Employee Id","Employee Name","Birthday","Helper"]
[null,18008,"Sheldon","1991-01-10",{"$f":"DATE(2020,MONTH(D4),DAY(D4))","v":"2020-01-10"}]
[null,18003,"Sara","1978-01-16",{"$f":"DATE(2020,MONTH(D5),DAY(D5))","v":"2020-01-16"}]
[null,18001,"Jefferson","1990-01-29",{"$f":"DATE(2020,MONTH(D6),DAY(D6))","v":"2020-01-29"}]
[null,18009,"Lara","1998-02-25",{"$f":"DATE(2020,MONTH(D7),DAY(D7))","v":"2020-02-25"}]
[null,18005,"Michael","1991-02-27",{"$f":"DATE(2020,MONTH(D8),DAY(D8))","v":"2020-02-27"}]
[null,18002,"Emily","1989-03-06",{"$f":"DATE(2020,MONTH(D9),DAY(D9))","v":"2020-03-06"}]
[null,18006,"Daniel","1995-03-12",{"$f":"DATE(2020,MONTH(D10),DAY(D10))","v":"2020-03-12"}]
[null,18010,"Kate","1992-03-26",{"$f":"DATE(2020,MONTH(D11),DAY(D11))","v":"2020-03-26"}]
[null,18004,"John","1992-05-13",{"$f":"DATE(2020,MONTH(D12),DAY(D12))","v":"2020-05-13"}]
[null,18007,"Gabriel","1980-05-18",{"$f":"DATE(2020,MONTH(D13),DAY(D13))","v":"2020-05-18"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"SORTBY","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using SORTBY and TEXT Functions"]
[]
[null,"Employee Name","Birthday",null,"Employee Name","Birthday"]
[null,"Jefferson","1990-01-29",null,{"$f":"_xlfn.SORTBY(B4:C13,TEXT(C4:C13,\"mdd\"))","v":"Sheldon"},"1991-01-10"]
[null,"Emily","1989-03-06",null,"Sara","1978-01-16"]
[null,"Sara","1978-01-16",null,"Jefferson","1990-01-29"]
[null,"John","1992-05-13",null,"Lara","1998-02-25"]
[null,"Michael","1991-02-27",null,"Michael","1991-02-27"]
[null,"Daniel","1995-03-12",null,"Emily","1989-03-06"]
[null,"Gabriel","1980-05-18",null,"Daniel","1995-03-12"]
[null,"Sheldon","1991-01-10",null,"Kate","1992-03-26"]
[null,"Lara","1998-02-25",null,"John","1992-05-13"]
[null,"Kate","1992-03-26",null,"Gabriel","1980-05-18"]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using VBA Code"]
[]
[null,"Employee Id","Employee Name","Birthday"]
[null,18008,"Sheldon","1991-01-10"]
[null,18003,"Sara","1978-01-16"]
[null,18001,"Jefferson","1990-01-29"]
[null,18009,"Lara","1998-02-25"]
[null,18005,"Michael","1991-02-27"]
[null,18002,"Emily","1989-03-06"]
[null,18006,"Daniel","1995-03-12"]
[null,18010,"Kate","1992-03-26"]
[null,18004,"John","1992-05-13"]
[null,18007,"Gabriel","1980-05-18"]

{"sheet":"Practice","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Practice"]
[]
[null,"Employee Id","Employee Name","Birthday"]
[null,18001,"Jefferson","1990-01-29"]
[null,18002,"Emily","1989-03-06"]
[null,18003,"Sara","1978-01-16"]
[null,18004,"John","1992-05-13"]
[null,18005,"Michael","1991-02-27"]
[null,18006,"Daniel","1995-03-12"]
[null,18007,"Gabriel","1980-05-18"]
[null,18008,"Sheldon","1991-01-10"]
[null,18009,"Lara","1998-02-25"]
[null,18010,"Kate","1992-03-26"]