{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SEARCH","Misc_Functions","Text to Column","VBA","Date_time"],"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":"SEARCH","index":0,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"SEARCH, MID & DATEVALUE Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text","Date",null,null,null,null,null,null,null,"Text","Date"]
[null,"Visit site on 10/04/2022",{"$f":"IFERROR(DATEVALUE(MID(B5,SEARCH(\"/??/\",B5,1)-2,10)),\"\")","v":"2022-04-10"},null,null,null,null,null,null,null,"Visit site on 10/04/2022"]
[null,"Arrange a meeting on 12/04/2022",{"$f":"IFERROR(DATEVALUE(MID(B6,SEARCH(\"/??/\",B6,1)-2,10)),\"\")","v":"2022-04-12"},null,null,null,null,null,null,null,"Arrange a meeting on 12/04/2022"]
[null,"14/02/2022 is holiday","2022-02-14",null,null,null,null,null,null,null,"14/02/2022 is holiday"]
[null,"On xx/yy/zz, contact supervisor","",null,null,null,null,null,null,null,"On xx/yy/zz, contact supervisor"]
[null,"15/03/2022 is the deadline","2022-03-15",null,null,null,null,null,null,null,"15/03/2022 is the deadline"]
[null,"Start the project on 10/05/2022","2022-05-10",null,null,null,null,null,null,null,"Start the project on 10/05/2022"]

{"sheet":"Misc_Functions","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"MIN, ROW, INDIRECT, FIND, MID & LEN Functions",null,null,null,null,null,null,null,null,"Try Tourself"]
[]
[null,"Text","Date",null,null,null,null,null,null,null,"Text","Date"]
[null,"Visit site on 10/04/2022",{"$f":"MID(B5,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\",1)),LEN(B5)+1)),LOOKUP(1,0*MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1),ROW(INDIRECT(\"1:\"&LEN(B5)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\",1)),LEN(B5)+1)))","v":"10/04/2022"},null,null,null,null,null,null,null,"Visit site on 10/04/2022"]
[null,"Arrange a meeting on 12/04/2022",{"$f":"MID(B6,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\",1)),LEN(B6)+1)),LOOKUP(1,0*MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1),ROW(INDIRECT(\"1:\"&LEN(B6)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\",1)),LEN(B6)+1)))","v":"12/04/2022"},null,null,null,null,null,null,null,"Arrange a meeting on 12/04/2022"]
[null,"14/02/2022 is holiday",{"$f":"MID(B7,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\",1)),LEN(B7)+1)),LOOKUP(1,0*MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1),ROW(INDIRECT(\"1:\"&LEN(B7)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\",1)),LEN(B7)+1)))","v":"14/02/2022"},null,null,null,null,null,null,null,"14/02/2022 is holiday"]
[null,"On 21/04/2022, contact supervisor",{"$f":"MID(B8,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\",1)),LEN(B8)+1)),LOOKUP(1,0*MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1),ROW(INDIRECT(\"1:\"&LEN(B8)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\",1)),LEN(B8)+1)))","v":"21/04/2022"},null,null,null,null,null,null,null,"On 21/04/2022, contact supervisor"]
[null,"15/03/2022 is the deadline",{"$f":"MID(B9,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B9&\"0123456789\",1)),LEN(B9)+1)),LOOKUP(1,0*MID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1),ROW(INDIRECT(\"1:\"&LEN(B9)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B9&\"0123456789\",1)),LEN(B9)+1)))","v":"15/03/2022"},null,null,null,null,null,null,null,"15/03/2022 is the deadline"]
[null,"Start the project on 10/05/2022",{"$f":"MID(B10,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B10&\"0123456789\",1)),LEN(B10)+1)),LOOKUP(1,0*MID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1),ROW(INDIRECT(\"1:\"&LEN(B10)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},B10&\"0123456789\",1)),LEN(B10)+1)))","v":"10/05/2022"},null,null,null,null,null,null,null,"Start the project on 10/05/2022"]

{"sheet":"Text to Column","index":2,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Meeting: 10/04/2022","2022-04-10"]
[null,"Holiday: 12/04/2022","2022-04-12",null,null,null,null,null,null,null,null,"Meeting: 10/04/2022"]
[null,"Birthday: 22/02/2022","2022-02-22",null,null,null,null,null,null,null,null,"Holiday: 12/04/2022"]
[null,"Tour: 21/04/2022","2022-04-21",null,null,null,null,null,null,null,null,"Birthday: 22/02/2022"]
[null,"Deadline: 15/03/2022","2022-03-15",null,null,null,null,null,null,null,null,"Tour: 21/04/2022"]
[null,"Birthday: 10/05/2022","2022-05-10",null,null,null,null,null,null,null,null,"Deadline: 15/03/2022"]
[null,null,null,null,null,null,null,null,null,null,null,"Birthday: 10/05/2022"]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text","Date","Final Date",null,null,null,null,null,null,"Text","Date","Final Date"]
[null,"Visit site on 10/04/2022",{"$f":"DateSeparate(B5)","v":"2022-04-10"},{"$f":"IF(DateSeparate(B5)=0,\"\",DateSeparate(B5))","v":"2022-04-10"},null,null,null,null,null,null,"Visit site on 10/04/2022"]
[null,"Arrange a meeting on 12/04/2022",{"$f":"DateSeparate(B6)","v":"2022-04-12"},{"$f":"IF(DateSeparate(B6)=0,\"\",DateSeparate(B6))","v":"2022-04-12"},null,null,null,null,null,null,"Arrange a meeting on 12/04/2022"]
[null,"14/02/2022 is holiday",{"$f":"DateSeparate(B7)","v":"2022-02-14"},{"$f":"IF(DateSeparate(B7)=0,\"\",DateSeparate(B7))","v":"2022-02-14"},null,null,null,null,null,null,"14/02/2022 is holiday"]
[null,"Contact supervisor on 15th",{"$f":"DateSeparate(B8)","v":"00:00:00"},{"$f":"IF(DateSeparate(B8)=0,\"\",DateSeparate(B8))","v":""},null,null,null,null,null,null,"Contact supervisor on 15th"]
[null,"15/03/2022 is the deadline",{"$f":"DateSeparate(B9)","v":"2022-03-15"},{"$f":"IF(DateSeparate(B9)=0,\"\",DateSeparate(B9))","v":"2022-03-15"},null,null,null,null,null,null,"15/03/2022 is the deadline"]
[null,"Start the project on 10/05/2022",{"$f":"DateSeparate(B10)","v":"2022-05-10"},{"$f":"IF(DateSeparate(B10)=0,\"\",DateSeparate(B10))","v":"2022-05-10"},null,null,null,null,null,null,"Start the project on 10/05/2022"]

{"sheet":"Date_time","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Separate Date & Time",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Datetime","Date","Time",null,null,null,null,null,null,"Datetime","Date","Time"]
[null,44661.395833333336,{"$f":"INT(B5)","v":44661},{"$f":"B5-C5","v":"09:30:00"},null,null,null,null,null,null,44661.395833333336]
[null,44663.523611111108,{"$f":"INT(B6)","v":"2022-04-12"},{"$f":"B6-C6","v":"12:34:00"},null,null,null,null,null,null,44663.523611111108]
[null,44606.416666666664,"2022-02-14","10:00:00",null,null,null,null,null,null,44606.416666666664]
[null,44672.388888888891,"2022-04-21","09:20:00",null,null,null,null,null,null,44672.388888888891]
[null,44635.111111111109,"2022-03-15","02:40:00",null,null,null,null,null,null,44635.111111111109]
[null,44691.184027777781,"2022-05-10","04:25:00",null,null,null,null,null,null,44691.184027777781]