{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["DATEVALUE","VALUE","Column Wizard","Text to date","Text to date (SUBSTITUTE)","Paste Special","Mathematical Operation","2 digit year","SUBSTITUTE","Find and Replace","Custom Number Format","8 digit text","Text to Column (Number)","Number to Date (TEXT)","VBA","Number (yyyymmdd) to Date","date with month name","date with day"],"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":"DATEVALUE","index":0,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using DATEVALUE Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","12-01-2021",{"$f":"DATEVALUE(C5)","v":"2021-12-01"},null,null,null,null,null,null,"Project A","12-01-2021"]
[null,"Project B","10-02-2020",{"$f":"DATEVALUE(C6)","v":"2020-10-02"},null,null,null,null,null,null,"Project B","10-02-2020"]
[null,"Project C","05-03-2018",{"$f":"DATEVALUE(C7)","v":"2018-05-03"},null,null,null,null,null,null,"Project C","05-03-2018"]
[null,"Project D","07-01-2015",{"$f":"DATEVALUE(C8)","v":"2015-07-01"},null,null,null,null,null,null,"Project D","07-01-2015"]
[null,"Project E","08-02-2012",{"$f":"DATEVALUE(C9)","v":"2012-08-02"},null,null,null,null,null,null,"Project E","08-02-2012"]

{"sheet":"VALUE","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using VALUE Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","12-01-2021",{"$f":"VALUE(C5)","v":"2021-12-01"},null,null,null,null,null,null,"Project A","12-01-2021"]
[null,"Project B","10-02-2020",{"$f":"VALUE(C6)","v":"2020-10-02"},null,null,null,null,null,null,"Project B","10-02-2020"]
[null,"Project C","05-03-2018","2018-05-03",null,null,null,null,null,null,"Project C","05-03-2018"]
[null,"Project D","07-01-2015","2015-07-01",null,null,null,null,null,null,"Project D","07-01-2015"]
[null,"Project E","08-02-2012","2012-08-02",null,null,null,null,null,null,"Project E","08-02-2012"]

{"sheet":"Column Wizard","index":2,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using Text to Column Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Text Format","Date","Day",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"08/11/2025, Monday","2025-08-11"," Monday",null,null,null,null,null,null,"Project A","12-01-2021"]
[null,"01/12/2024, Friday","2024-01-12"," Friday",null,null,null,null,null,null,"Project B","10-02-2020"]
[null,"12/04/2023, Monday","2023-12-04"," Monday",null,null,null,null,null,null,"Project C","05-03-2018"]
[null,"04/06/2023, Thursday","2023-04-06"," Thursday",null,null,null,null,null,null,"Project D","07-01-2015"]
[null,"09/18/2023, Monday","2023-09-18"," Monday",null,null,null,null,null,null,"Project E","08-02-2012"]
[null,"11/11/2024, Monday","2024-11-11"," Monday"]
[null,"10/08/2025, Wednesday","2025-10-08"," Wednesday"]

{"sheet":"Text to date","index":3,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Converting Detailed Text Date to Short Date",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","Tuesday, 04 February 2025",{"$f":"DATEVALUE(RIGHT(C5,LEN(C5)-FIND(\" \",C5)))","v":"2025-02-04"},null,null,null,null,null,null,"Project A","Tuesday, 04 February 2025"]
[null,"Project B","Tuesday, 25 February 2025",{"$f":"DATEVALUE(RIGHT(C6,LEN(C6)-FIND(\" \",C6)))","v":"2025-02-25"},null,null,null,null,null,null,"Project B","Tuesday, 25 February 2025"]
[null,"Project C","Saturday, 25 October 2025","2025-10-25",null,null,null,null,null,null,"Project C","Saturday, 25 October 2025"]
[null,"Project D","Sunday, 14 July 2024","2024-07-14",null,null,null,null,null,null,"Project D","Sunday, 14 July 2024"]
[null,"Project E","Tuesday, 24 September 2024","2024-09-24",null,null,null,null,null,null,"Project E","Tuesday, 24 September 2024"]

{"sheet":"Text to date (SUBSTITUTE)","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Converting Ordinal Text Dates to Dates",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","15th Mar 2025",{"$f":"DATEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C5,\"th\",\"\"),\"st\",\"\"),\"rd\",\"\"),\"nd\",\"\"))","v":45731},null,null,null,null,null,null,"Project A","15th Mar 2025"]
[null,"Project B","18th Aug 2025",{"$f":"DATEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C6,\"th\",\"\"),\"st\",\"\"),\"rd\",\"\"),\"nd\",\"\"))","v":45887},null,null,null,null,null,null,"Project B","18th Aug 2025"]
[null,"Project C","10th Aug 2025",45879,null,null,null,null,null,null,"Project C","10th Aug 2025"]
[null,"Project D","22th Jun 2025",45830,null,null,null,null,null,null,"Project D","22th Jun 2025"]
[null,"Project E","10th Apr 2025",45757,null,null,null,null,null,null,"Project E","10th Apr 2025"]

{"sheet":"Paste Special","index":5,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using Paste Special Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","12-01-2021","2021-12-01",null,null,null,null,null,null,"Project A","12-01-2021"]
[null,"Project B","10-02-2020","2020-10-02",null,null,null,null,null,null,"Project B","10-02-2020"]
[null,"Project C","05-03-2018","2018-05-03",null,null,null,null,null,null,"Project C","05-03-2018"]
[null,"Project D","07-01-2015","2015-07-01",null,null,null,null,null,null,"Project D","07-01-2015"]
[null,"Project E","08-02-2012","2012-08-02",null,null,null,null,null,null,"Project E","08-02-2012"]

{"sheet":"Mathematical Operation","index":6,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Mathematical Operation",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","12-01-2021",{"$f":"C5+0","v":"2021-12-01"},null,null,null,null,null,null,"Project A","12-01-2021"]
[null,"Project B","10-02-2020",{"$f":"C6+0","v":"2020-10-02"},null,null,null,null,null,null,"Project B","10-02-2020"]
[null,"Project C","05-03-2018","2018-05-03",null,null,null,null,null,null,"Project C","05-03-2018"]
[null,"Project D","07-01-2015","2015-07-01",null,null,null,null,null,null,"Project D","07-01-2015"]
[null,"Project E","08-02-2012","2012-08-02",null,null,null,null,null,null,"Project E","08-02-2012"]

{"sheet":"2 digit year","index":7,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Converting Dates with Two Digit Year",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","12/1/2021",{"$f":"VALUE(C5)","v":"2021-12-01"},null,null,null,null,null,null,"Project A","12/1/21"]
[null,"Project B","10/2/2020",{"$f":"VALUE(C6)","v":"2020-10-02"},null,null,null,null,null,null,"Project B","10/2/20"]
[null,"Project C","5/3/2018","2018-05-03",null,null,null,null,null,null,"Project C","5/3/18"]
[null,"Project D","7/1/2015","2015-07-01",null,null,null,null,null,null,"Project D","7/1/15"]
[null,"Project E","8/2/2012","2012-08-02",null,null,null,null,null,null,"Project E","8/2/12"]

{"sheet":"SUBSTITUTE","index":8,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using SUBSTITUTE Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","12.01.2021",{"$f":"VALUE(SUBSTITUTE(C5,\".\",\"-\"))","v":"2021-12-01"},null,null,null,null,null,null,"Project A","12-01-2021"]
[null,"Project B","10.02.2020",{"$f":"VALUE(SUBSTITUTE(C6,\".\",\"-\"))","v":"2020-10-02"},null,null,null,null,null,null,"Project B","10-02-2020"]
[null,"Project C","05.03.2018","2018-05-03",null,null,null,null,null,null,"Project C","05-03-2018"]
[null,"Project D","07.01.2015","2015-07-01",null,null,null,null,null,null,"Project D","07-01-2015"]
[null,"Project E","08.02.2012","2012-08-02",null,null,null,null,null,null,"Project E","08-02-2012"]

{"sheet":"Find and Replace","index":9,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,11]]}
[]
[null,"Using Find & Replace Feature",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Text Format",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","2021-12-01",null,null,null,null,null,null,"Project A","12-01-2021"]
[null,"Project B","2020-10-02",null,null,null,null,null,null,"Project B","10-02-2020"]
[null,"Project C","2018-05-03",null,null,null,null,null,null,"Project C","05-03-2018"]
[null,"Project D","2015-07-01",null,null,null,null,null,null,"Project D","07-01-2015"]
[null,"Project E","2012-08-02",null,null,null,null,null,null,"Project E","08-02-2012"]

{"sheet":"Custom Number Format","index":10,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Converting Number to Date",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number",null,null,null,null,null,null,"Project","Number"]
[null,"Project A","2024-03-29",null,null,null,null,null,null,"Project A",45380]
[null,"Project B","2023-10-08",null,null,null,null,null,null,"Project B",45207]
[null,"Project C","2023-09-29",null,null,null,null,null,null,"Project C",45198]
[null,"Project D","2023-05-23",null,null,null,null,null,null,"Project D",45069]
[null,"Project E","2023-10-15",null,null,null,null,null,null,"Project E",45214]

{"sheet":"8 digit text","index":11,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Converting 8 Digit Text to Date",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","09142021",{"$f":"DATE(RIGHT(C5,4),LEFT(C5,2),MID(C5,3,2))","v":"2021-09-14"},null,null,null,null,null,null,"Project A","09142021"]
[null,"Project B","11092021",{"$f":"DATE(RIGHT(C6,4),LEFT(C6,2),MID(C6,3,2))","v":"2021-11-09"},null,null,null,null,null,null,"Project B","11092021"]
[null,"Project C","21012022","2023-09-01",null,null,null,null,null,null,"Project C","21012022"]
[null,"Project D","08062023","2023-08-06",null,null,null,null,null,null,"Project D","08062023"]
[null,"Project E","04282022","2022-04-28",null,null,null,null,null,null,"Project E","04282022"]

{"sheet":"Text to Column (Number)","index":12,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Converting Number to Date (Text to Column)",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A",20200415,"2020-04-15",null,null,null,null,null,null,"Project A",20200415]
[null,"Project B",20200403,"2020-04-03",null,null,null,null,null,null,"Project B",20200403]
[null,"Project C",20200407,"2020-04-07",null,null,null,null,null,null,"Project C",20200407]
[null,"Project D",20200427,"2020-04-27",null,null,null,null,null,null,"Project D",20200427]
[null,"Project E",20200401,"2020-04-01",null,null,null,null,null,null,"Project E",20200401]

{"sheet":"Number to Date (TEXT)","index":13,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,11]]}
[]
[null,"Converting Number to Date (TEXT Function)",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number","Date",null,null,null,null,null,null,"Project","Number"]
[null,"Project A",45380,{"$f":"TEXT(C5,\"mm-dd-yyyy\")","v":"03-29-2024"},null,null,null,null,null,null,"Project A",45380]
[null,"Project B",45207,{"$f":"TEXT(C6,\"mm-dd-yyyy\")","v":"10-08-2023"},null,null,null,null,null,null,"Project B",45207]
[null,"Project C",45198,"09-29-2023",null,null,null,null,null,null,"Project C",45198]
[null,"Project D",45069,"05-23-2023",null,null,null,null,null,null,"Project D",45069]
[null,"Project E",45214,"10-15-2023",null,null,null,null,null,null,"Project E",45214]

{"sheet":"VBA","index":14,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,11]]}
[]
[null,"VBA to Convert YYYYMMDD to Date",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number Format",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","2020-04-15",null,null,null,null,null,null,"Project A",20200415]
[null,"Project B","2020-04-03",null,null,null,null,null,null,"Project B",20200403]
[null,"Project C","2020-04-07",null,null,null,null,null,null,"Project C",20200407]
[null,"Project D","2020-04-27",null,null,null,null,null,null,"Project D",20200427]
[null,"Project E","2020-03-31",null,null,null,null,null,null,"Project E",20200401]

{"sheet":"Number (yyyymmdd) to Date","index":15,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Converting 8 Digit Number to Date",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A",20200415,{"$f":"DATE(LEFT(C5,4),MID(C5,5,2),RIGHT(C5,2))","v":"2020-04-15"},null,null,null,null,null,null,"Project A",20200415]
[null,"Project B",20200403,{"$f":"DATE(LEFT(C6,4),MID(C6,5,2),RIGHT(C6,2))","v":"2020-04-03"},null,null,null,null,null,null,"Project B",20200403]
[null,"Project C",20200407,"2020-04-07",null,null,null,null,null,null,"Project C",20200407]
[null,"Project D",20200427,"2020-04-27",null,null,null,null,null,null,"Project D",20200427]
[null,"Project E",20200400,"2020-03-31",null,null,null,null,null,null,"Project E",20200400]

{"sheet":"date with month name","index":16,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Date with Month Name",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","2024 April 22",{"$f":"DATEVALUE(RIGHT(C5,2)&\"-\"&TEXT(MID(C5,6,3),\"MMM\")&\"-\"&LEFT(C5,4))","v":"2024-04-22"},null,null,null,null,null,null,"Project A","2024 April 22"]
[null,"Project B","2025 July 15",{"$f":"DATEVALUE(RIGHT(C6,2)&\"-\"&TEXT(MID(C6,6,3),\"MMM\")&\"-\"&LEFT(C6,4))","v":"2025-07-15"},null,null,null,null,null,null,"Project B","2025 July 15"]
[null,"Project C","2025 March 10","2025-03-10",null,null,null,null,null,null,"Project C","2025 March 10"]
[null,"Project D","2024 July 22","2024-07-22",null,null,null,null,null,null,"Project D","2024 July 22"]
[null,"Project E","2025 February 01","2025-02-01",null,null,null,null,null,null,"Project E","2025 February 01"]

{"sheet":"date with day","index":17,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Date with Day Name at the End",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project","Number Format","Formatted Date",null,null,null,null,null,null,"Project","Text Format","Formatted Date"]
[null,"Project A","2022-Apr-16, Sat",{"$f":"DATEVALUE(MID(C5,10,2)&\"-\"&MID(C5,6,3)&\"-\"&LEFT(C5,4))","v":"2022-04-16"},null,null,null,null,null,null,"Project A","2022-Apr-16, Sat"]
[null,"Project B","2024-Nov-04, Mon",{"$f":"DATEVALUE(MID(C6,10,2)&\"-\"&MID(C6,6,3)&\"-\"&LEFT(C6,4))","v":"2024-11-04"},null,null,null,null,null,null,"Project B","2024-Nov-04, Mon"]
[null,"Project C","2024-Aug-15, Thu","2024-08-15",null,null,null,null,null,null,"Project C","2024-Aug-15, Thu"]
[null,"Project D","2024-May-15, Wed","2024-05-15",null,null,null,null,null,null,"Project D","2024-May-15, Wed"]
[null,"Project E","2024-Dec-20, Fri","2024-12-20",null,null,null,null,null,null,"Project E","2024-Dec-20, Fri"]