{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FILTER","PIvot Table","Filter Function","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"FILTER","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Filter Dates by Month and Year in Excel"]
[]
[null,"Date","Sales Qty","Revenue"]
[null,"2022-05-03",10,450]
[null,"2022-05-15",15,650]
[null,"2021-06-05",35,360]
[null,"2022-03-26",12,260]
[null,"2021-04-11",32,575]
[null,"2022-06-24",12,350]
[null,"2020-01-23",18,560]
[null,"2022-02-28",5,720]

{"sheet":"PIvot Table","index":1,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Filter Dates by Month and Year Using Pivot Table"]
[]
[null,"Date","Sales Qty","Revenue",null,"Sum of Sales Qty","Column Labels"]
[null,"2022-05-03",10,450,null,"Row Labels","2020","2021","2022","Grand Total"]
[null,"2022-05-15",15,650,null,"Jan",18,null,null,18]
[null,"2021-06-05",35,360,null,"Feb",null,null,5,5]
[null,"2022-03-26",12,260,null,"Mar",null,null,12,12]
[null,"2021-04-11",32,575,null,"Apr",null,32,null,32]
[null,"2022-06-24",12,350,null,"May",null,null,25,25]
[null,"2020-01-23",18,560,null,"Jun",null,35,12,47]
[null,"2022-02-28",5,720,null,"Grand Total",18,67,54,139]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"p"]

{"sheet":"Filter Function","index":2,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,12,3,13],[7,12,7,14],[1,12,1,14],[7,5,7,7],[3,5,3,6],[1,1,1,7]]}
[]
[null,"Filtering Dates by Month and Year Using FILTER Function",null,null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Date","Sales Qty","Revenue",null,"Filter Criteria",null,null,null,null,null,null,"Filter Criteria"]
[null,"2022-05-03",10,450,null,"Month",5,null,null,null,null,null,"Month"]
[null,"2022-05-15",15,650,null,"Year",2022,null,null,null,null,null,"Year"]
[null,"2021-06-05",35,360]
[null,"2022-03-26",12,260,null,"Filtered Output",null,null,null,null,null,null,"Filtered Output"]
[null,"2021-04-11",32,575,null,"Date","Sales Qty","Revenue",null,null,null,null,"Date","Sales Qty","Revenue"]
[null,"2022-06-24",12,350,null,{"$f":"_xlfn._xlws.FILTER(B5:D12,(MONTH(B5:B12)=G5)*(YEAR(B5:B12)=G6),\"N/A\")","v":"2022-05-03"},10,450]
[null,"2020-01-23",18,560,null,44696,15,650]
[null,"2022-02-28",5,720]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"s"]

{"sheet":"VBA","index":3,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Filtering Dates by Month and Year Using VBA ",null,null,null,"Filter Criteria"]
[null,null,null,null,null,"Start Date","2022-01-31"]
[null,"Date","Sales Qty","Revenue",null,"End Date","2022-12-31"]
[null,"2022-05-03",10,450]
[null,"2022-05-15",15,650]
[null,"2021-06-05",35,360]
[null,"2022-03-26",12,260]
[null,"2021-04-11",32,575]
[null,"2022-06-24",12,350]
[null,"2020-01-23",18,560]
[null,"2022-02-28",5,720]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"s"]