{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Date Format","Dataset 1","Add 2 Cells","Dataset 2","DATE Function","Dataset 3","Paste Special","YEAR, MONTH, and DAY Functions","VBA Macro","Dataset 4","Adding Weekends","Adding Months","Adding Years","Dataset 5 ","TRIM 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":"Date Format","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Changing Date Format"]
[]
[null,"Date","Long Dates"]
[null,"2022-12-22","2022-12-22"]
[null,"2022-12-23","2022-12-23"]
[null,"2022-12-24","2022-12-24"]
[null,"2022-12-25","2022-12-25"]
[null,"2022-12-26","2022-12-26"]
[null,"2022-12-27","2022-12-27"]

{"sheet":"Dataset 1","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Updated Promotion Dates "]
[]
[null,"Dates","Days (+/-)","Promotion Dates"]
[null,"2020-03-02",-5]
[null,"2020-06-05",-14]
[null,"2020-07-01",14]
[null,"2020-12-10",15]
[null,"2020-08-23",30]

{"sheet":"Add 2 Cells","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Adding 2 Cells to Add Days",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Dates","Days (+/-)","Promotion Dates",null,null,null,null,"Dates","Days (+/-)","Promotion Dates"]
[null,"2020-03-02",-5,{"$f":"B5+C5","v":"2020-02-26"},null,null,null,null,"2020-03-02",-5]
[null,"2020-06-05",-14,{"$f":"B6+C6","v":"2020-05-22"},null,null,null,null,"2020-06-05",-14]
[null,"2020-07-01",14,"2020-07-15",null,null,null,null,"2020-07-01",14]
[null,"2020-12-10",15,"2020-12-25",null,null,null,null,"2020-12-10",15]
[null,"2020-08-23",30,"2020-09-22",null,null,null,null,"2020-08-23",30]

{"sheet":"Dataset 2","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Project Deadlines"]
[]
[null,"Year","Month","Day","Days (+/-)","Updated Date"]
[null,2022,10,3,-5]
[null,2022,6,5,-14]
[null,2022,8,7,14]
[null,2022,9,12,15]
[null,2022,11,23,30]

{"sheet":"DATE Function","index":4,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using DATE Function ",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Year","Month","Day","Days (+/-)","Updated Date",null,null,null,null,"Year","Month","Day","Days (+/-)","Updated Date"]
[null,2022,10,3,-5,{"$f":"DATE(B5,C5,D5+E5)","v":"2022-09-28"},null,null,null,null,2022,10,3,-5]
[null,2022,6,5,-14,{"$f":"DATE(B6,C6,D6+E6)","v":"2022-05-22"},null,null,null,null,2022,6,5,-14]
[null,2022,8,7,14,"2022-08-21",null,null,null,null,2022,8,7,14]
[null,2022,9,12,15,"2022-09-27",null,null,null,null,2022,9,12,15]
[null,2022,11,23,30,"2022-12-23",null,null,null,null,2022,11,23,30]

{"sheet":"Dataset 3","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,2,8,2]]}
[]
[null,"New Promotion Dates "]
[]
[null,"Dates","Increase By","Promotion Dates"]
[null,"2020-03-02",10]
[null,"2020-06-05"]
[null,"2020-07-01"]
[null,"2020-12-10"]
[null,"2020-08-23"]

{"sheet":"Paste Special","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,2,8,2],[1,9,1,11],[4,10,8,10]]}
[]
[null,"Utilizing Paste Special Feature",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Dates","Increase By","Promotion Dates",null,null,null,null,null,"Dates","Increase By","Promotion Dates"]
[null,"2020-03-02",10,"2020-03-12",null,null,null,null,null,"2020-03-02",10]
[null,"2020-06-05",null,"2020-06-05",null,null,null,null,null,"2020-06-05"]
[null,"2020-07-01",null,"2020-07-01",null,null,null,null,null,"2020-07-01"]
[null,"2020-12-10",null,"2020-12-10",null,null,null,null,null,"2020-12-10"]
[null,"2020-08-23",null,"2020-08-23",null,null,null,null,null,"2020-08-23"]

{"sheet":"YEAR, MONTH, and DAY Functions","index":7,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Employing YEAR, MONTH, and DAY Functions",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Dates","Days (+/-)","Promotion Dates",null,null,null,null,"Dates","Days (+/-)","Promotion Dates"]
[null,"2020-03-02",-5,{"$f":"DATE(YEAR(B5),MONTH(B5),DAY(B5)+C5)","v":"2020-02-26"},null,null,null,null,"2020-03-02",-5]
[null,"2020-06-05",-14,{"$f":"DATE(YEAR(B6),MONTH(B6),DAY(B6)+C6)","v":"2020-05-22"},null,null,null,null,"2020-06-05",-14]
[null,"2020-07-01",14,"2020-07-15",null,null,null,null,"2020-07-01",14]
[null,"2020-12-10",15,"2020-12-25",null,null,null,null,"2020-12-10",15]
[null,"2020-08-23",30,"2020-09-22",null,null,null,null,"2020-08-23",30]

{"sheet":"VBA Macro","index":8,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using VBA Macro",null,null,null,null,null,"Practice Section"]
[]
[null,"Dates","Updated Dates",null,null,null,null,"Dates","Updated Dates"]
[null,"2020-03-02","2020-03-03",null,null,null,null,"2020-03-02"]
[null,"2020-06-05","2020-06-06",null,null,null,null,"2020-06-05"]
[null,"2020-07-01","2020-07-02",null,null,null,null,"2020-07-01"]
[null,"2020-12-10","2020-12-11",null,null,null,null,"2020-12-10"]
[null,"2020-08-23","2020-08-24",null,null,null,null,"2020-08-23"]

{"sheet":"Dataset 4","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Project Deadline Update"]
[]
[null,"Project Name","Deadlines","Weekends","New Deadlines"]
[null,"Project 1","2020-03-02",5]
[null,"Project 2","2021-06-05",4]
[null,"Project 3","2022-04-15",7]
[null,"Project 4","2021-08-14",14]
[null,"Project 5","2021-12-31",2]

{"sheet":"Adding Weekends","index":10,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Adding Weekends to Date",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Project Name","Deadlines","Weekends","New Deadlines",null,null,null,null,null,"Project Name","Deadlines","Weekends","New Deadlines"]
[null,"Project 1","2020-03-02",5,{"$f":"WORKDAY(C5,D5)","v":"2020-03-09"},null,null,null,null,null,"Project 1","2020-03-02",5]
[null,"Project 2","2021-06-05",4,{"$f":"WORKDAY(C6,D6)","v":"2021-06-10"},null,null,null,null,null,"Project 2","2021-06-05",4]
[null,"Project 3","2022-04-15",7,"2022-04-26",null,null,null,null,null,"Project 3","2022-04-15",7]
[null,"Project 4","2021-08-14",14,"2021-09-02",null,null,null,null,null,"Project 4","2021-08-14",14]
[null,"Project 5","2021-12-31",2,"2022-01-04",null,null,null,null,null,"Project 5","2021-12-31",2]

{"sheet":"Adding Months","index":11,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Adding Months to Date",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Dates","Months","Promotion Dates",null,null,null,null,"Dates","Months","Promotion Dates"]
[null,"2020-03-02",6,{"$f":"DATE(YEAR(B5),MONTH(B5)+C5,DAY(B5))","v":"2020-09-02"},null,null,null,null,"2020-03-02",6]
[null,"2020-06-05",6,{"$f":"DATE(YEAR(B6),MONTH(B6)+C6,DAY(B6))","v":"2020-12-05"},null,null,null,null,"2020-06-05",6]
[null,"2020-07-01",6,"2021-01-01",null,null,null,null,"2020-07-01",6]
[null,"2020-12-10",10,"2021-10-10",null,null,null,null,"2020-12-10",10]
[null,"2020-08-23",10,"2021-06-23",null,null,null,null,"2020-08-23",10]

{"sheet":"Adding Years","index":12,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Adding Years to Date",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Dates","Years","Promotion Dates",null,null,null,null,"Dates","Years","Promotion Dates"]
[null,"2020-03-02",3,{"$f":"DATE(YEAR(B5)+C5,MONTH(B5),DAY(B5))","v":"2023-03-02"},null,null,null,null,"2020-03-02",3]
[null,"2020-06-05",3,{"$f":"DATE(YEAR(B6)+C6,MONTH(B6),DAY(B6))","v":"2023-06-05"},null,null,null,null,"2020-06-05",3]
[null,"2020-07-01",3,"2023-07-01",null,null,null,null,"2020-07-01",3]
[null,"2020-12-10",5,"2025-12-10",null,null,null,null,"2020-12-10",5]
[null,"2020-08-23",5,"2025-08-23",null,null,null,null,"2020-08-23",5]

{"sheet":"Dataset 5 ","index":13,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adding Days to Date Not Working"]
[]
[null,"Dates","Days (+/-)","Promotion Dates"]
[null," 3/2/2020",-5]
[null," 6/5/2020 ",-14]
[null," 7/1/2020",14]
[null," 12/10/2020",15]
[null," 8/23/2020",30]

{"sheet":"TRIM Function","index":14,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Removing Preceding Space ",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Dates","Days (+/-)","Promotion Dates",null,null,null,null,"Dates","Days (+/-)","Promotion Dates"]
[null," 3/2/2020",-5,{"$f":"TRIM(B5)+C5","v":"2020-02-26"},null,null,null,null," 3/2/2020",-5]
[null," 6/5/2020 ",-14,{"$f":"TRIM(B6)+C6","v":"2020-05-22"},null,null,null,null," 6/5/2020 ",-14]
[null," 7/1/2020",14,"2020-07-15",null,null,null,null," 7/1/2020",14]
[null," 12/10/2020",15,"2020-12-25",null,null,null,null," 12/10/2020",15]
[null," 8/23/2020",30,"2020-09-22",null,null,null,null," 8/23/2020",30]