{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["dataset","filter command 1","filter command 2","filter","Sheet3","pivot","vba","and today","do it yourself"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":1},"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":"dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Filter \nDate Range in Excel"]
[]
[null,"Date","Products","Sales Qty."]
[null,"2022-01-02","OnePlus Mobile",7]
[null,"2022-01-03","Dell Laptop",4]
[null,"2022-01-06","iPhone",3]
[null,"2022-01-08","Xiaomi Mobile",12]
[null,"2022-01-20","Samsung Mobile",5]
[null,"2022-02-01","HP Laptop",4]
[null,"2022-02-05","Vivo Mobile",11]
[null,"2022-02-07","Xperia Mobile",1]
[null,"2022-03-11","JBL Headphones",10]
[null,"2022-03-17","Logitech Gamepad",9]

{"sheet":"filter command 1","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Filter \nDate Range in Excel"]
[]
[null,"Date","Products","Sales Qty."]
[null,"2022-01-02","OnePlus Mobile",7]
[null,"2022-01-03","Dell Laptop",4]
[null,"2022-01-06","iPhone",3]
[null,"2022-01-08","Xiaomi Mobile",12]
[null,"2022-01-20","Samsung Mobile",5]
[null,"2022-03-11","JBL Headphones",10]
[null,"2022-03-17","Logitech Gamepad",9]

{"sheet":"filter command 2","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Filter \nDate Range in Excel"]
[]
[null,"Date","Products","Sales Qty."]
[null,"2022-01-02","OnePlus Mobile",7]
[null,"2022-01-03","Dell Laptop",4]
[null,"2022-01-06","iPhone",3]
[null,"2022-01-08","Xiaomi Mobile",12]
[null,"2022-01-20","Samsung Mobile",5]
[null,"2022-02-01","HP Laptop",4]
[null,"2022-02-05","Vivo Mobile",11]
[null,"2022-02-07","Xperia Mobile",1]
[null,"2022-03-11","JBL Headphones",10]
[null,"2022-03-17","Logitech Gamepad",9]

{"sheet":"filter","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Filter \nDate Range in Excel"]
[]
[null,"Date","Products","Sales Qty.",null,"Date","Products","Sales Qty."]
[null,"2022-01-02","OnePlus Mobile",7,null,{"$f":"_xlfn._xlws.FILTER(B5:D14,MONTH(B5:B14)=2,\"No data\")","v":"2022-02-01"},"HP Laptop",4]
[null,"2022-01-03","Dell Laptop",4,null,"2022-02-05","Vivo Mobile",11]
[null,"2022-01-06","iPhone",3,null,"2022-02-07","Xperia Mobile",1]
[null,"2022-01-08","Xiaomi Mobile",12]
[null,"2022-01-20","Samsung Mobile",5]
[null,"2022-02-01","HP Laptop",4]
[null,"2022-02-05","Vivo Mobile",11]
[null,"2022-02-07","Xperia Mobile",1]
[null,"2022-03-11","JBL Headphones",10]
[null,"2022-03-17","Logitech Gamepad",9]

{"sheet":"Sheet3","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Months","Jan"]
[]
["Row Labels","Sum of Sales Qty."]
["Dell Laptop",4]
["iPhone",3]
["OnePlus Mobile",7]
["Samsung Mobile",5]
["Xiaomi Mobile",12]
["Grand Total",31]

{"sheet":"pivot","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Filter \nDate Range in Excel"]
[]
[null,"Date","Products","Sales Qty."]
[null,"2022-01-02","OnePlus Mobile",7]
[null,"2022-01-03","Dell Laptop",4]
[null,"2022-01-06","iPhone",3]
[null,"2022-01-08","Xiaomi Mobile",12]
[null,"2022-01-20","Samsung Mobile",5]
[null,"2022-02-01","HP Laptop",4]
[null,"2022-02-05","Vivo Mobile",11]
[null,"2022-02-07","Xperia Mobile",1]
[null,"2022-03-11","JBL Headphones",10]
[null,"2022-03-17","Logitech Gamepad",9]

{"sheet":"vba","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Filter \nDate Range in Excel"]
[]
[null,"Date","Products","Sales Qty."]
[null,"2022-01-02","OnePlus Mobile",7]
[null,"2022-01-03","Dell Laptop",4]
[null,"2022-01-06","iPhone",3]
[null,"2022-01-08","Xiaomi Mobile",12]
[null,"2022-01-20","Samsung Mobile",5]
[null,"2022-02-01","HP Laptop",4]
[null,"2022-02-05","Vivo Mobile",11]
[null,"2022-02-07","Xperia Mobile",1]
[null,"2022-03-11","JBL Headphones",10]
[null,"2022-03-17","Logitech Gamepad",9]

{"sheet":"and today","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Filter \nDate Range in Excel"]
[]
[null,"Date","Products","Sales Qty.","Filtered Date"]
[null,"2022-01-02","OnePlus Mobile",7,{"$f":"AND(TODAY()-B5>=60,TODAY()-B5<=80)","v":false}]
[null,"2022-01-03","Dell Laptop",4,{"$f":"AND(TODAY()-B6>=60,TODAY()-B6<=80)","v":false}]
[null,"2022-01-06","iPhone",3,{"$f":"AND(TODAY()-B7>=60,TODAY()-B7<=80)","v":true}]
[null,"2022-01-08","Xiaomi Mobile",12,true]
[null,"2022-01-20","Samsung Mobile",5,true]
[null,"2022-02-01","HP Laptop",4,false]
[null,"2022-02-05","Vivo Mobile",11,false]
[null,"2022-02-07","Xperia Mobile",1,false]
[null,"2022-03-11","JBL Headphones",10,false]
[null,"2022-03-17","Logitech Gamepad",9,false]

{"sheet":"do it yourself","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do It Yourself"]
[]
[null,"Date","Products","Sales Qty."]
[null,"2022-01-02","OnePlus Mobile",7]
[null,"2022-01-03","Dell Laptop",4]
[null,"2022-01-06","iPhone",3]
[null,"2022-01-08","Xiaomi Mobile",12]
[null,"2022-01-20","Samsung Mobile",5]
[null,"2022-02-01","HP Laptop",4]
[null,"2022-02-05","Vivo Mobile",11]
[null,"2022-02-07","Xperia Mobile",1]
[null,"2022-03-11","JBL Headphones",10]
[null,"2022-03-17","Logitech Gamepad",9]