{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["overview","Formula Expresssions","year","quarter","month","day_of_year","weekday","week","hour","minute","second","minus"],"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":"overview","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,4]]}
[]
[null,null,"Use of Excel VBA DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"y-Year","2","2022-01-01","DateAdd(\"yyyy\", -2, Range(\"D5\")","2020-01-01"]
[null,"q-Quarter","2","2022-01-01","DateAdd(\"q\", 2, Range(\"D5\")","2022-07-01"]
[null,"m-Month","2","2022-01-01","DateAdd(\"m\", 2, Range(\"D5\")","2022-03-01"]
[null,"d-Day","2","2022-01-01","DateAdd(\"d\", 2, Range(\"D5\")","2022-01-03"]
[null,"w-WeekDay","10","2022-01-01","DateAdd(\"w\", 10, Range(\"D5\")","2022-01-11"]
[null,"ww-Week","2","2022-01-01","DateAdd(\"ww\", 10, Range(\"D5\")","2022-01-15"]
[null,"h-Hour","14","2022-01-01","DateAdd(\"h\", 14, Range(\"D5\")","2022-01-01T14:00:00"]
[null,"n-Minute","90","2022-01-01","DateAdd(\"n\", 90, Range(\"D5\")","2022-01-01T01:30:00"]
[null,"n-Minute","120","2022-01-01","DateAdd(\"s\", 120, Range(\"D5\")","2021-12-31T23:58:00"]
[null,"Subtract","2","2022-01-01","DateAdd(\"yyyy\", -2, Range(\"D5\")","2020-01-01"]

{"sheet":"Formula Expresssions","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Input Types","Formula Expressions","Outputs"]
[null,"#1/1/2022#","DateAdd(\"yyyy\", 2, #1/1/2022#)","2024-01-01"]
[null,"DateSerial(2022, 1, 1)","DateAdd(\"yyyy\", 2, DateSerial(2022, 1, 1))","2024-01-01"]
[null,"DateValue(\"Jan 1, 2022\")","DateAdd(\"yyyy\", 2, DateValue(\"Jan 1, 2022\"))","2024-01-01"]
[null,"2022-01-01","DateAdd(\"yyyy\", 2, Range(\"B6\"))","2024-01-01"]
[null,"Variable"," Dim dt As Date\n    dt = #1/1/2022#\n     DateAdd(\"yyyy\", 2, dt)","2024-01-01"]

{"sheet":"year","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Year Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"Year","2","2022-01-01","DateAdd(\"yyyy\", 2, Range(\"D5\")","2024-01-01"]
[null,"Arguments"]

{"sheet":"quarter","index":3,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Quarter Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"q-Quarter","2","2022-01-01","DateAdd(\"q\", 2, Range(\"D5\")","2022-07-01"]
[null,"Arguments"]

{"sheet":"month","index":4,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Month Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"m-Month","2","2022-01-01","DateAdd(\"m\", 2, Range(\"D5\")","2022-03-01"]
[null,"Arguments"]

{"sheet":"day_of_year","index":5,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Day Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"d-Day","2","2022-01-01","DateAdd(\"d\", 2, Range(\"D5\")","2022-01-03"]
[null,"Arguments"]

{"sheet":"weekday","index":6,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add WeekDay Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"w-WeekDay","10","2022-01-01","DateAdd(\"w\", 10, Range(\"D5\")","2022-01-11"]
[null,"Arguments"]

{"sheet":"week","index":7,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Week Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"ww-Week","2","2022-01-01","DateAdd(\"ww\", 10, Range(\"D5\")","2022-01-15"]
[null,"Arguments"]

{"sheet":"hour","index":8,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Hours Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"h-Hour","14","2022-01-01","DateAdd(\"h\", 14, Range(\"D5\")","2022-01-01T14:00:00"]
[null,"Arguments"]

{"sheet":"minute","index":9,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Minutes Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"n-Minute","90","2022-01-01","DateAdd(\"n\", 90, Range(\"D5\")","2022-01-01T01:30:00"]
[null,"Arguments"]

{"sheet":"second","index":10,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Add Seconds Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"n-Minute","120","2022-01-01","DateAdd(\"s\", 120, Range(\"D5\")","2021-12-31T23:58:00"]
[null,"Arguments"]

{"sheet":"minus","index":11,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,1,5,3]]}
[]
[null,null,"Subtract Year Using DateAdd Function"]
[]
[null,"interval","number","date","Formula Expresssion","Result"]
[null,"y-Year","2","2022-01-01","DateAdd(\"yyyy\", -2, Range(\"D5\")","2020-01-01"]
[null,"Arguments"]