{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Fill Series Feature","Fill Series Feature to Subtract","Adding 7 to Previous Date","Subtracting 7 ","Using TODAY function","Using TODAY to Subtract","Using DATE Function","DATE Function to Subtract","Paste Special","Using VBA Code"],"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":"Fill Series Feature","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Fill Series Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,null,null,null,null,null,"Book Name ","Price","Delivery Date "]
[null,"Around the World in 80 Days",30,"2021-09-28",null,null,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28"]
[null,"A Thousand Splendid Suns",25,"2021-10-05",null,null,null,null,null,null,"A Thousand Splendid Suns",25]
[null,"Clash of Civilizations",45,"2021-10-12",null,null,null,null,null,null,"Clash of Civilizations",45]
[null,"A Song of Ice and Fire",60,"2021-10-19",null,null,null,null,null,null,"A Song of Ice and Fire",60]
[null,"The Lord of the Rings",90,"2021-10-26",null,null,null,null,null,null,"The Lord of the Rings",90]
[null,"The Three Musketeers",70,"2021-11-02",null,null,null,null,null,null,"The Three Musketeers",70]
[null,"Les Misérables",55,"2021-11-09",null,null,null,null,null,null,"Les Misérables",55]
[null,"The Count of Monte Cristo",65,"2021-11-16",null,null,null,null,null,null,"The Count of Monte Cristo",65]
[null,"The Kite Runner",40,"2021-11-23",null,null,null,null,null,null,"The Kite Runner",40]
[null,"King Solomon's Mines",45,"2021-11-30",null,null,null,null,null,null,"King Solomon's Mines",45]
[null,"Nada the Lilly ",90,"2021-12-07",null,null,null,null,null,null,"Nada the Lilly ",90]
[null,"The Man in the Iron Mask",100,"2021-12-14",null,null,null,null,null,null,"The Man in the Iron Mask",100]
[null,"The Hound of the Baskervilles",60,"2021-12-21",null,null,null,null,null,null,"The Hound of the Baskervilles",60]
[null,"The Valley of Fear",75,"2021-12-28",null,null,null,null,null,null,"The Valley of Fear",75]

{"sheet":"Fill Series Feature to Subtract","index":1,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Fill Series Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,null,null,null,null,null,"Book Name ","Price","Delivery Date "]
[null,"Around the World in 80 Days",30,"2021-09-28",null,null,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28"]
[null,"A Thousand Splendid Suns",25,"2021-09-21",null,null,null,null,null,null,"A Thousand Splendid Suns",25]
[null,"Clash of Civilizations",45,"2021-09-14",null,null,null,null,null,null,"Clash of Civilizations",45]
[null,"A Song of Ice and Fire",60,"2021-09-07",null,null,null,null,null,null,"A Song of Ice and Fire",60]
[null,"The Lord of the Rings",90,"2021-08-31",null,null,null,null,null,null,"The Lord of the Rings",90]
[null,"The Three Musketeers",70,"2021-08-24",null,null,null,null,null,null,"The Three Musketeers",70]
[null,"Les Misérables",55,"2021-08-17",null,null,null,null,null,null,"Les Misérables",55]
[null,"The Count of Monte Cristo",65,"2021-08-10",null,null,null,null,null,null,"The Count of Monte Cristo",65]
[null,"The Kite Runner",40,"2021-08-03",null,null,null,null,null,null,"The Kite Runner",40]
[null,"King Solomon's Mines",45,"2021-07-27",null,null,null,null,null,null,"King Solomon's Mines",45]
[null,"Nada the Lilly ",90,"2021-07-20",null,null,null,null,null,null,"Nada the Lilly ",90]
[null,"The Man in the Iron Mask",100,"2021-07-13",null,null,null,null,null,null,"The Man in the Iron Mask",100]
[null,"The Hound of the Baskervilles",60,"2021-07-06",null,null,null,null,null,null,"The Hound of the Baskervilles",60]
[null,"The Valley of Fear",75,"2021-06-29",null,null,null,null,null,null,"The Valley of Fear",75]

{"sheet":"Adding 7 to Previous Date","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Application of Generic Formula",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,null,null,null,null,null,"Book Name ","Price","Delivery Date "]
[null,"Around the World in 80 Days",30,"2021-09-28",null,null,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28"]
[null,"A Thousand Splendid Suns",25,{"$f":"D5+7","v":"2021-10-05"},null,null,null,null,null,null,"A Thousand Splendid Suns",25]
[null,"Clash of Civilizations",45,{"$f":"D6+7","v":"2021-10-12"},null,null,null,null,null,null,"Clash of Civilizations",45]
[null,"A Song of Ice and Fire",60,"2021-10-19",null,null,null,null,null,null,"A Song of Ice and Fire",60]
[null,"The Lord of the Rings",90,"2021-10-26",null,null,null,null,null,null,"The Lord of the Rings",90]
[null,"The Three Musketeers",70,"2021-11-02",null,null,null,null,null,null,"The Three Musketeers",70]
[null,"Les Misérables",55,"2021-11-09",null,null,null,null,null,null,"Les Misérables",55]
[null,"The Count of Monte Cristo",65,"2021-11-16",null,null,null,null,null,null,"The Count of Monte Cristo",65]
[null,"The Kite Runner",40,"2021-11-23",null,null,null,null,null,null,"The Kite Runner",40]
[null,"King Solomon's Mines",45,"2021-11-30",null,null,null,null,null,null,"King Solomon's Mines",45]
[null,"Nada the Lilly ",90,"2021-12-07",null,null,null,null,null,null,"Nada the Lilly ",90]
[null,"The Man in the Iron Mask",100,"2021-12-14",null,null,null,null,null,null,"The Man in the Iron Mask",100]
[null,"The Hound of the Baskervilles",60,"2021-12-21",null,null,null,null,null,null,"The Hound of the Baskervilles",60]
[null,"The Valley of Fear",75,"2021-12-28",null,null,null,null,null,null,"The Valley of Fear",75]

{"sheet":"Subtracting 7 ","index":3,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Application of Generic Formula",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,null,null,null,null,null,"Book Name ","Price","Delivery Date "]
[null,"Around the World in 80 Days",30,"2021-09-28",null,null,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28"]
[null,"A Thousand Splendid Suns",25,{"$f":"D5-7","v":"2021-09-21"},null,null,null,null,null,null,"A Thousand Splendid Suns",25]
[null,"Clash of Civilizations",45,{"$f":"D6-7","v":"2021-09-14"},null,null,null,null,null,null,"Clash of Civilizations",45]
[null,"A Song of Ice and Fire",60,"2021-09-07",null,null,null,null,null,null,"A Song of Ice and Fire",60]
[null,"The Lord of the Rings",90,"2021-08-31",null,null,null,null,null,null,"The Lord of the Rings",90]
[null,"The Three Musketeers",70,"2021-08-24",null,null,null,null,null,null,"The Three Musketeers",70]
[null,"Les Misérables",55,"2021-08-17",null,null,null,null,null,null,"Les Misérables",55]
[null,"The Count of Monte Cristo",65,"2021-08-10",null,null,null,null,null,null,"The Count of Monte Cristo",65]
[null,"The Kite Runner",40,"2021-08-03",null,null,null,null,null,null,"The Kite Runner",40]
[null,"King Solomon's Mines",45,"2021-07-27",null,null,null,null,null,null,"King Solomon's Mines",45]
[null,"Nada the Lilly ",90,"2021-07-20",null,null,null,null,null,null,"Nada the Lilly ",90]
[null,"The Man in the Iron Mask",100,"2021-07-13",null,null,null,null,null,null,"The Man in the Iron Mask",100]
[null,"The Hound of the Baskervilles",60,"2021-07-06",null,null,null,null,null,null,"The Hound of the Baskervilles",60]
[null,"The Valley of Fear",75,"2021-06-29",null,null,null,null,null,null,"The Valley of Fear",75]

{"sheet":"Using TODAY function","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of TODAY Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Days Remained","Delivery Date ",null,null,null,null,null,"Book Name ","Price","Days Remained","Delivery Date "]
[null,"Around the World in 80 Days",30,0,{"$f":"TODAY()+D5","v":"2022-12-05"},null,null,null,null,null,"Around the World in 80 Days",30,0]
[null,"A Thousand Splendid Suns",25,7,{"$f":"TODAY()+D6","v":"2022-12-12"},null,null,null,null,null,"A Thousand Splendid Suns",25,7]
[null,"Clash of Civilizations",45,14,{"$f":"TODAY()+D7","v":"2022-12-19"},null,null,null,null,null,"Clash of Civilizations",45,14]
[null,"A Song of Ice and Fire",60,21,"2022-12-26",null,null,null,null,null,"A Song of Ice and Fire",60,21]
[null,"The Lord of the Rings",90,28,"2023-01-02",null,null,null,null,null,"The Lord of the Rings",90,28]
[null,"The Three Musketeers",70,35,"2023-01-09",null,null,null,null,null,"The Three Musketeers",70,35]
[null,"Les Misérables",55,42,"2023-01-16",null,null,null,null,null,"Les Misérables",55,42]
[null,"The Count of Monte Cristo",65,49,"2023-01-23",null,null,null,null,null,"The Count of Monte Cristo",65,49]
[null,"The Kite Runner",40,56,"2023-01-30",null,null,null,null,null,"The Kite Runner",40,56]
[null,"King Solomon's Mines",45,63,"2023-02-06",null,null,null,null,null,"King Solomon's Mines",45,63]
[null,"Nada the Lilly ",90,70,"2023-02-13",null,null,null,null,null,"Nada the Lilly ",90,70]
[null,"The Man in the Iron Mask",100,77,"2023-02-20",null,null,null,null,null,"The Man in the Iron Mask",100,77]
[null,"The Hound of the Baskervilles",60,84,"2023-02-27",null,null,null,null,null,"The Hound of the Baskervilles",60,84]
[null,"The Valley of Fear",75,91,"2023-03-06",null,null,null,null,null,"The Valley of Fear",75,91]

{"sheet":"Using TODAY to Subtract","index":5,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of TODAY Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Days Remained","Delivery Date ",null,null,null,null,null,"Book Name ","Price","Days Remained","Delivery Date "]
[null,"Around the World in 80 Days",30,0,{"$f":"TODAY()-D5","v":"2022-12-05"},null,null,null,null,null,"Around the World in 80 Days",30,0]
[null,"A Thousand Splendid Suns",25,7,{"$f":"TODAY()-D6","v":"2022-11-28"},null,null,null,null,null,"A Thousand Splendid Suns",25,7]
[null,"Clash of Civilizations",45,14,"2022-11-21",null,null,null,null,null,"Clash of Civilizations",45,14]
[null,"A Song of Ice and Fire",60,21,"2022-11-14",null,null,null,null,null,"A Song of Ice and Fire",60,21]
[null,"The Lord of the Rings",90,28,"2022-11-07",null,null,null,null,null,"The Lord of the Rings",90,28]
[null,"The Three Musketeers",70,35,"2022-10-31",null,null,null,null,null,"The Three Musketeers",70,35]
[null,"Les Misérables",55,42,"2022-10-24",null,null,null,null,null,"Les Misérables",55,42]
[null,"The Count of Monte Cristo",65,49,"2022-10-17",null,null,null,null,null,"The Count of Monte Cristo",65,49]
[null,"The Kite Runner",40,56,"2022-10-10",null,null,null,null,null,"The Kite Runner",40,56]
[null,"King Solomon's Mines",45,63,"2022-10-03",null,null,null,null,null,"King Solomon's Mines",45,63]
[null,"Nada the Lilly ",90,70,"2022-09-26",null,null,null,null,null,"Nada the Lilly ",90,70]
[null,"The Man in the Iron Mask",100,77,"2022-09-19",null,null,null,null,null,"The Man in the Iron Mask",100,77]
[null,"The Hound of the Baskervilles",60,84,"2022-09-12",null,null,null,null,null,"The Hound of the Baskervilles",60,84]
[null,"The Valley of Fear",75,91,"2022-09-05",null,null,null,null,null,"The Valley of Fear",75,91]

{"sheet":"Using DATE Function","index":6,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Application of DATE Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,null,null,null,null,null,"Book Name ","Price","Delivery Date "]
[null,"Around the World in 80 Days",30,"2021-09-28",null,null,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28"]
[null,"A Thousand Splendid Suns",25,{"$f":"DATE(YEAR(D5),MONTH(D5),DAY(D5)+7)","v":"2021-10-05"},null,null,null,null,null,null,"A Thousand Splendid Suns",25]
[null,"Clash of Civilizations",45,{"$f":"DATE(YEAR(D6),MONTH(D6),DAY(D6)+7)","v":"2021-10-12"},null,null,null,null,null,null,"Clash of Civilizations",45]
[null,"A Song of Ice and Fire",60,"2021-10-19",null,null,null,null,null,null,"A Song of Ice and Fire",60]
[null,"The Lord of the Rings",90,"2021-10-26",null,null,null,null,null,null,"The Lord of the Rings",90]
[null,"The Three Musketeers",70,"2021-11-02",null,null,null,null,null,null,"The Three Musketeers",70]
[null,"Les Misérables",55,"2021-11-09",null,null,null,null,null,null,"Les Misérables",55]
[null,"The Count of Monte Cristo",65,"2021-11-16",null,null,null,null,null,null,"The Count of Monte Cristo",65]
[null,"The Kite Runner",40,"2021-11-23",null,null,null,null,null,null,"The Kite Runner",40]
[null,"King Solomon's Mines",45,"2021-11-30",null,null,null,null,null,null,"King Solomon's Mines",45]
[null,"Nada the Lilly ",90,"2021-12-07",null,null,null,null,null,null,"Nada the Lilly ",90]
[null,"The Man in the Iron Mask",100,"2021-12-14",null,null,null,null,null,null,"The Man in the Iron Mask",100]
[null,"The Hound of the Baskervilles",60,"2021-12-21",null,null,null,null,null,null,"The Hound of the Baskervilles",60]
[null,"The Valley of Fear",75,"2021-12-28",null,null,null,null,null,null,"The Valley of Fear",75]

{"sheet":"DATE Function to Subtract","index":7,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Application of DATE Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,null,null,null,null,null,"Book Name ","Price","Delivery Date "]
[null,"Around the World in 80 Days",30,"2021-09-28",null,null,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28"]
[null,"A Thousand Splendid Suns",25,{"$f":"DATE(YEAR(D5),MONTH(D5),DAY(D5)-7)","v":"2021-09-21"},null,null,null,null,null,null,"A Thousand Splendid Suns",25]
[null,"Clash of Civilizations",45,{"$f":"DATE(YEAR(D6),MONTH(D6),DAY(D6)-7)","v":"2021-09-14"},null,null,null,null,null,null,"Clash of Civilizations",45]
[null,"A Song of Ice and Fire",60,"2021-09-07",null,null,null,null,null,null,"A Song of Ice and Fire",60]
[null,"The Lord of the Rings",90,"2021-08-31",null,null,null,null,null,null,"The Lord of the Rings",90]
[null,"The Three Musketeers",70,"2021-08-24",null,null,null,null,null,null,"The Three Musketeers",70]
[null,"Les Misérables",55,"2021-08-17",null,null,null,null,null,null,"Les Misérables",55]
[null,"The Count of Monte Cristo",65,"2021-08-10",null,null,null,null,null,null,"The Count of Monte Cristo",65]
[null,"The Kite Runner",40,"2021-08-03",null,null,null,null,null,null,"The Kite Runner",40]
[null,"King Solomon's Mines",45,"2021-07-27",null,null,null,null,null,null,"King Solomon's Mines",45]
[null,"Nada the Lilly ",90,"2021-07-20",null,null,null,null,null,null,"Nada the Lilly ",90]
[null,"The Man in the Iron Mask",100,"2021-07-13",null,null,null,null,null,null,"The Man in the Iron Mask",100]
[null,"The Hound of the Baskervilles",60,"2021-07-06",null,null,null,null,null,null,"The Hound of the Baskervilles",60]
[null,"The Valley of Fear",75,"2021-06-29",null,null,null,null,null,null,"The Valley of Fear",75]

{"sheet":"Paste Special","index":8,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Paste Special Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,"Add",null,null,null,null,"Book Name ","Price","Delivery Date ",null,"Add"]
[null,"Around the World in 80 Days",30,"2021-09-28",null,7,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28",null,7]
[null,"A Thousand Splendid Suns",25,"2021-10-05",null,null,null,null,null,null,"A Thousand Splendid Suns",25]
[null,"Clash of Civilizations",45,"2021-10-12",null,null,null,null,null,null,"Clash of Civilizations",45]
[null,"A Song of Ice and Fire",60,"2021-10-19",null,null,null,null,null,null,"A Song of Ice and Fire",60]
[null,"The Lord of the Rings",90,"2021-10-26",null,null,null,null,null,null,"The Lord of the Rings",90]
[null,"The Three Musketeers",70,"2021-11-02",null,null,null,null,null,null,"The Three Musketeers",70]
[null,"Les Misérables",55,"2021-11-09",null,null,null,null,null,null,"Les Misérables",55]
[null,"The Count of Monte Cristo",65,"2021-11-16",null,null,null,null,null,null,"The Count of Monte Cristo",65]
[null,"The Kite Runner",40,"2021-11-23",null,null,null,null,null,null,"The Kite Runner",40]
[null,"King Solomon's Mines",45,"2021-11-30",null,null,null,null,null,null,"King Solomon's Mines",45]
[null,"Nada the Lilly ",90,"2021-12-07",null,null,null,null,null,null,"Nada the Lilly ",90]
[null,"The Man in the Iron Mask",100,"2021-12-14",null,null,null,null,null,null,"The Man in the Iron Mask",100]
[null,"The Hound of the Baskervilles",60,"2021-12-21",null,null,null,null,null,null,"The Hound of the Baskervilles",60]
[null,"The Valley of Fear",75,"2021-12-28",null,null,null,null,null,null,"The Valley of Fear",75]

{"sheet":"Using VBA Code","index":9,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Book Name ","Price","Delivery Date ",null,null,null,null,null,null,"Book Name ","Price","Delivery Date "]
[null,"Around the World in 80 Days",30,"2021-09-28",null,null,null,null,null,null,"Around the World in 80 Days",30,"2021-09-28"]
[null,"A Thousand Splendid Suns",25,"2021-09-29",null,null,null,null,null,null,"A Thousand Splendid Suns",25,"2021-09-29"]
[null,"Clash of Civilizations",45,"2021-09-30",null,null,null,null,null,null,"Clash of Civilizations",45,"2021-09-30"]
[null,"A Song of Ice and Fire",60,"2021-10-08",null,null,null,null,null,null,"A Song of Ice and Fire",60,"2021-10-01"]
[null,"The Lord of the Rings",90,"2021-10-09",null,null,null,null,null,null,"The Lord of the Rings",90,"2021-10-02"]
[null,"The Three Musketeers",70,"2021-10-10",null,null,null,null,null,null,"The Three Musketeers",70,"2021-10-03"]
[null,"Les Misérables",55,"2021-10-11",null,null,null,null,null,null,"Les Misérables",55,"2021-10-04"]
[null,"The Count of Monte Cristo",65,"2021-10-12",null,null,null,null,null,null,"The Count of Monte Cristo",65,"2021-10-05"]
[null,"The Kite Runner",40,"2021-10-13",null,null,null,null,null,null,"The Kite Runner",40,"2021-10-06"]
[null,"King Solomon's Mines",45,"2021-10-07",null,null,null,null,null,null,"King Solomon's Mines",45,"2021-10-07"]
[null,"Nada the Lilly ",90,"2021-10-08",null,null,null,null,null,null,"Nada the Lilly ",90,"2021-10-08"]
[null,"The Man in the Iron Mask",100,"2021-10-09",null,null,null,null,null,null,"The Man in the Iron Mask",100,"2021-10-09"]
[null,"The Hound of the Baskervilles",60,"2021-10-10",null,null,null,null,null,null,"The Hound of the Baskervilles",60,"2021-10-10"]
[null,"The Valley of Fear",75,"2021-10-11",null,null,null,null,null,null,"The Valley of Fear",75,"2021-10-11"]