{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Home Page","Overview","Simple","DATE","SUM","PasteSpecial","Table1","PowerQuery","VBA","CustomFunction"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Home Page","index":0,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"How to Add Weeks to a Date in Excel"]
[]
[null,"Learn how to add weeks to a date in Excel with this free workbook. Read the article we provided and practice these in the practice section."]
[]
[]
[null,"Prepared By","Aung Shine"]
[null,"Reviewed By","A.N.M. Mohaimen Shanto"]
[null,"Last Update","2023-11-09"]
[null,"Article Link","How to Extract Unique Values Based on Criteria in Excel"]
[]
[null,"Methods"]
[]
[null,"1. Using a Simple Arithmetic Formula to Add Weeks to a Date"]
[null,"2. Adding Weeks to a Date with Excel DATE Function"]
[null,"3. Inserting SUM Function to Add Weeks to a Date in Excel"]
[null,"4. Adding Weeks to a Date Through Paste Special Tool"]
[null,"5. Using Excel Power Query for Adding Weeks to a Date"]
[null,"6. Adding Weeks to a Date with Excel VBA"]
[null,"     6.1 Through Creating Macro"]
[null,"     6.2 By Creating User-Defined Function"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Overview","index":1,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date"]
[]
[null,"Project ","Start Date","Weeks to Finish","Deadline"]
[null,"A","2023-10-01",1,{"$f":"C5+D5*7","v":"2023-10-08"}]
[null,"B","2023-01-16",3,{"$f":"C6+D6*7","v":"2023-02-06"}]
[null,"C","2023-02-20",2,"2023-03-06"]
[null,"D","2023-05-29",6,"2023-07-10"]
[null,"E","2023-10-16",5,"2023-11-20"]
[null,"F","2023-07-04",4,"2023-08-01"]
[null,"G","2023-09-04",5,"2023-10-09"]
[null,"H","2023-10-09",4,"2023-11-06"]
[null,"I","2023-11-11",3,"2023-12-02"]
[null,"J","2023-11-23",2,"2023-12-07"]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Simple","index":2,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date",null,null,null,null,null,"Adding Weeks to a Date"]
[]
[null,"Using a Simple Arithmetic Formula",null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ","Start Date","Weeks to Finish","Deadline",null,null,"Project ","Start Date","Weeks to Finish","Deadline"]
[null,"A","2023-10-01",1,{"$f":"C7+D7*7","v":"2023-10-08"},null,null,"A","2023-10-01",1]
[null,"B","2023-01-16",3,{"$f":"C8+D8*7","v":"2023-02-06"},null,null,"B","2023-01-16",3]
[null,"C","2023-02-20",2,"2023-03-06",null,null,"C","2023-02-20",2]
[null,"D","2023-05-29",6,"2023-07-10",null,null,"D","2023-05-29",6]
[null,"E","2023-10-16",5,"2023-11-20",null,null,"E","2023-10-16",5]
[null,"F","2023-07-04",4,"2023-08-01",null,null,"F","2023-07-04",4]
[null,"G","2023-09-04",5,"2023-10-09",null,null,"G","2023-09-04",5]
[null,"H","2023-10-09",4,"2023-11-06",null,null,"H","2023-10-09",4]
[null,"I","2023-11-11",3,"2023-12-02",null,null,"I","2023-11-11",3]
[null,"J","2023-11-23",2,"2023-12-07",null,null,"J","2023-11-23",2]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"DATE","index":3,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date",null,null,null,null,null,"Adding Weeks to a Date"]
[]
[null,"Using DATE Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ","Start Date","Weeks to Finish","Deadline",null,null,"Project ","Start Date","Weeks to Finish","Deadline"]
[null,"A","2023-10-01",1,{"$f":"DATE(YEAR(C7),MONTH(C7),DAY(C7)+7*D7)","v":"2023-10-08"},null,null,"A","2023-10-01",1]
[null,"B","2023-01-16",3,{"$f":"DATE(YEAR(C8),MONTH(C8),DAY(C8)+7*D8)","v":"2023-02-06"},null,null,"B","2023-01-16",3]
[null,"C","2023-02-20",2,"2023-03-06",null,null,"C","2023-02-20",2]
[null,"D","2023-05-29",6,"2023-07-10",null,null,"D","2023-05-29",6]
[null,"E","2023-10-16",5,"2023-11-20",null,null,"E","2023-10-16",5]
[null,"F","2023-07-04",4,"2023-08-01",null,null,"F","2023-07-04",4]
[null,"G","2023-09-04",5,"2023-10-09",null,null,"G","2023-09-04",5]
[null,"H","2023-10-09",4,"2023-11-06",null,null,"H","2023-10-09",4]
[null,"I","2023-11-11",3,"2023-12-02",null,null,"I","2023-11-11",3]
[null,"J","2023-11-23",2,"2023-12-07",null,null,"J","2023-11-23",2]
[]
[]
[null,"Back to Home Page"]

{"sheet":"SUM","index":4,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date",null,null,null,null,null,"Adding Weeks to a Date"]
[]
[null,"Using SUM Function",null,null,null,null,null,"Try Yourself"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(SUM(C7,D7*7),\"d-mmm-yyyy\")*1","v":"2023-10-08"}]
[null,"Project ","Start Date","Weeks to Finish","Deadline",null,null,"Project ","Start Date","Weeks to Finish","Deadline"]
[null,"A","2023-10-01",1,{"$f":"SUM(C7,D7*7)*1","v":"2023-10-08"},null,null,"A","2023-10-01",1,{"$f":"SUM(I7,J7*7)*1","v":"2023-10-08"}]
[null,"B","2023-01-16",3,{"$f":"SUM(C8,D8*7)*1","v":"2023-02-06"},null,null,"B","2023-01-16",3]
[null,"C","2023-02-20",2,"2023-03-06",null,null,"C","2023-02-20",2]
[null,"D","2023-05-29",6,"2023-07-10",null,null,"D","2023-05-29",6]
[null,"E","2023-10-16",5,"2023-11-20",null,null,"E","2023-10-16",5]
[null,"F","2023-07-04",4,"2023-08-01",null,null,"F","2023-07-04",4]
[null,"G","2023-09-04",5,"2023-10-09",null,null,"G","2023-09-04",5]
[null,"H","2023-10-09",4,"2023-11-06",null,null,"H","2023-10-09",4]
[null,"I","2023-11-11",3,"2023-12-02",null,null,"I","2023-11-11",3]
[null,"J","2023-11-23",2,"2023-12-07",null,null,"J","2023-11-23",2]
[]
[]
[null,"Back to Home Page"]

{"sheet":"PasteSpecial","index":5,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date",null,null,null,null,null,null,"Adding Weeks to a Date"]
[]
[null,"Using Paste Special Tool",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ","Start Date","Weeks to Finish","Days to Finish","Deadline",null,null,"Project ","Start Date","Weeks to Finish","Days to Finish","Deadline"]
[null,"A","2023-10-01",1,{"$f":"D7*7","v":7},"2023-10-08",null,null,"A","2023-10-01",1]
[null,"B","2023-01-16",3,{"$f":"D8*7","v":21},"2023-02-06",null,null,"B","2023-01-16",3]
[null,"C","2023-02-20",2,14,"2023-03-06",null,null,"C","2023-02-20",2]
[null,"D","2023-05-29",6,42,"2023-07-10",null,null,"D","2023-05-29",6]
[null,"E","2023-10-16",5,35,"2023-11-20",null,null,"E","2023-10-16",5]
[null,"F","2023-07-04",4,28,"2023-08-01",null,null,"F","2023-07-04",4]
[null,"G","2023-09-04",5,35,"2023-10-09",null,null,"G","2023-09-04",5]
[null,"H","2023-10-09",4,28,"2023-11-06",null,null,"H","2023-10-09",4]
[null,"I","2023-11-11",3,21,"2023-12-02",null,null,"I","2023-11-11",3]
[null,"J","2023-11-23",2,14,"2023-12-07",null,null,"J","2023-11-23",2]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Table1","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Project ","Start Date","Weeks to Finish","Deadline"]
["A","2023-10-01",1,"2023-10-08"]
["B","2023-01-16",3,"2023-02-06"]
["C","2023-02-20",2,"2023-03-06"]
["D","2023-05-29",6,"2023-07-10"]
["E","2023-10-16",5,"2023-11-20"]
["F","2023-07-04",4,"2023-08-01"]
["G","2023-09-04",5,"2023-10-09"]
["H","2023-10-09",4,"2023-11-06"]
["I","2023-11-11",3,"2023-12-02"]
["J","2023-11-23",2,"2023-12-07"]

{"sheet":"PowerQuery","index":7,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date",null,null,null,null,"Adding Weeks to a Date"]
[]
[null,"Using Power Query",null,null,null,null,"Try Yourself"]
[]
[null,"Project ","Start Date","Weeks to Finish",null,null,"Project ","Start Date","Weeks to Finish"]
[null,"A","2023-10-01",1,null,null,"A","2023-10-01",1]
[null,"B","2023-01-16",3,null,null,"B","2023-01-16",3]
[null,"C","2023-02-20",2,null,null,"C","2023-02-20",2]
[null,"D","2023-05-29",6,null,null,"D","2023-05-29",6]
[null,"E","2023-10-16",5,null,null,"E","2023-10-16",5]
[null,"F","2023-07-04",4,null,null,"F","2023-07-04",4]
[null,"G","2023-09-04",5,null,null,"G","2023-09-04",5]
[null,"H","2023-10-09",4,null,null,"H","2023-10-09",4]
[null,"I","2023-11-11",3,null,null,"I","2023-11-11",3]
[null,"J","2023-11-23",2,null,null,"J","2023-11-23",2]
[]
[]
[null,"Back to Home Page"]

{"sheet":"VBA","index":8,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date",null,null,null,null,null,"Adding Weeks to a Date"]
[]
[null,"Using VBA Macro",null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ","Start Date","Weeks to Finish","Deadline",null,null,"Project ","Start Date","Weeks to Finish","Deadline"]
[null,"A","2023-10-01",1,"2023-10-08",null,null,"A","2023-10-01",1]
[null,"B","2023-01-16",3,"2023-02-06",null,null,"B","2023-01-16",3]
[null,"C","2023-02-20",2,"2023-03-06",null,null,"C","2023-02-20",2]
[null,"D","2023-05-29",6,"2023-07-10",null,null,"D","2023-05-29",6]
[null,"E","2023-10-16",5,"2023-11-20",null,null,"E","2023-10-16",5]
[null,"F","2023-07-04",4,"2023-08-01",null,null,"F","2023-07-04",4]
[null,"G","2023-09-04",5,"2023-10-09",null,null,"G","2023-09-04",5]
[null,"H","2023-10-09",4,"2023-11-06",null,null,"H","2023-10-09",4]
[null,"I","2023-11-11",3,"2023-12-02",null,null,"I","2023-11-11",3]
[null,"J","2023-11-23",2,"2023-12-07",null,null,"J","2023-11-23",2]
[]
[]
[null,"Back to Home Page"]

{"sheet":"CustomFunction","index":9,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adding Weeks to a Date",null,null,null,null,null,"Adding Weeks to a Date"]
[]
[null,"Using VBA User-Defined Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ","Start Date","Weeks to Finish","Deadline",null,null,"Project ","Start Date","Weeks to Finish","Deadline"]
[null,"A","2023-10-01",1,{"$f":"AddWeekstoDate(C7,D7)","v":"2023-10-08"},null,null,"A","2023-10-01",1]
[null,"B","2023-01-16",3,{"$f":"AddWeekstoDate(C8,D8)","v":"2023-02-06"},null,null,"B","2023-01-16",3]
[null,"C","2023-02-20",2,{"$f":"AddWeekstoDate(C9,D9)","v":"2023-03-06"},null,null,"C","2023-02-20",2]
[null,"D","2023-05-29",6,{"$f":"AddWeekstoDate(C10,D10)","v":"2023-07-10"},null,null,"D","2023-05-29",6]
[null,"E","2023-10-16",5,{"$f":"AddWeekstoDate(C11,D11)","v":"2023-11-20"},null,null,"E","2023-10-16",5]
[null,"F","2023-07-04",4,{"$f":"AddWeekstoDate(C12,D12)","v":"2023-08-01"},null,null,"F","2023-07-04",4]
[null,"G","2023-09-04",5,{"$f":"AddWeekstoDate(C13,D13)","v":"2023-10-09"},null,null,"G","2023-09-04",5]
[null,"H","2023-10-09",4,{"$f":"AddWeekstoDate(C14,D14)","v":"2023-11-06"},null,null,"H","2023-10-09",4]
[null,"I","2023-11-11",3,{"$f":"AddWeekstoDate(C15,D15)","v":"2023-12-02"},null,null,"I","2023-11-11",3]
[null,"J","2023-11-23",2,{"$f":"AddWeekstoDate(C16,D16)","v":"2023-12-07"},null,null,"J","2023-11-23",2]
[]
[]
[null,"Back to Home Page"]