{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sample Dataset","COUNTA","Combination","Sumproduct(MONTH)","SUMPRODUCT(YEAR)","COUNTIF Current Month","COUNTIF Previous Month","VBA","Practice"],"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":"Sample Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date"]
[null,"Robert Hills","2022-08-01","2025-12-01"]
[null,"John Kabir","2022-04-10","2024-12-10"]
[null,"Tom Hanks","2022-01-01","2026-12-01"]
[null,"Manuel jack","2022-05-01","2030-12-01"]
[null,"Austin Cooper","2022-07-05","2024-12-05"]
[null,"Sam Williams","2022-06-06","2023-12-06"]

{"sheet":"COUNTA","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date",null,"Dates"]
[null,"Robert Hills","2022-08-01","2025-12-01",null,{"$f":"COUNTA(D6:D11)","v":6}]
[null,"John Kabir","2022-04-10","2024-12-10"]
[null,"Tom Hanks","2022-01-01","2026-12-01"]
[null,"Manuel jack","2022-05-01","2030-12-01"]
[null,"Austin Cooper","2022-07-05","2024-12-05"]
[null,"Sam Williams","2022-06-06","2023-12-06"]

{"sheet":"Combination","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date",null,"Date Count"]
[null,"Robert Hills","2022-08-01","2025-12-01",null,{"$f":"SUM(IF(ISERROR(DATEVALUE(TEXT(D6:D11, \"dd/MM/yyyy\"))), 0, 1))","v":6}]
[null,"John Kabir","2022-04-10","2024-12-10"]
[null,"Tom Hanks","2022-01-01","2026-12-01"]
[null,"Manuel jack","2022-05-01","2030-12-01"]
[null,"Austin Cooper","2022-07-05","2024-12-05"]
[null,"Sam Williams","2022-06-06","2023-12-06"]

{"sheet":"Sumproduct(MONTH)","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Date of Birth",null,"Birthdays","Count"]
[null,"Robert Hills","2022-08-01","1995-01-01",null,"January",{"$f":"SUMPRODUCT(--(MONTH($D$6:$D$11)=MONTH($F6&1)))","v":2}]
[null,"John Kabir","2022-04-10","1994-03-12",null,"February",{"$f":"SUMPRODUCT(--(MONTH($D$6:$D$11)=MONTH($F7&1)))","v":1}]
[null,"Tom Hanks","2022-01-01","1993-05-11",null,"March",{"$f":"SUMPRODUCT(--(MONTH($D$6:$D$11)=MONTH($F8&1)))","v":1}]
[null,"Manuel jack","2022-05-01","1995-07-18",null,"April",{"$f":"SUMPRODUCT(--(MONTH($D$6:$D$11)=MONTH($F9&1)))","v":0}]
[null,"Austin Cooper","2022-07-05","1992-01-21",null,"May",{"$f":"SUMPRODUCT(--(MONTH($D$6:$D$11)=MONTH($F10&1)))","v":1}]
[null,"Sam Williams","2022-06-06","1995-02-14",null,"June",{"$f":"SUMPRODUCT(--(MONTH($D$6:$D$11)=MONTH($F11&1)))","v":0}]

{"sheet":"SUMPRODUCT(YEAR)","index":4,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date",null,"Year","Counts"]
[null,"Robert Hills","2022-08-01","2025-12-01",null,2024,{"$f":"SUMPRODUCT(--(YEAR($D$6:$D$11)=$F6))","v":2}]
[null,"John Kabir","2022-04-10","2024-12-10",null,2025,{"$f":"SUMPRODUCT(--(YEAR($D$6:$D$11)=$F7))","v":1}]
[null,"Tom Hanks","2022-01-01","2026-12-01",null,2026,{"$f":"SUMPRODUCT(--(YEAR($D$6:$D$11)=$F8))","v":1}]
[null,"Manuel jack","2022-05-01","2030-12-01",null,2027,{"$f":"SUMPRODUCT(--(YEAR($D$6:$D$11)=$F9))","v":0}]
[null,"Austin Cooper","2022-07-05","2024-12-05",null,2028,{"$f":"SUMPRODUCT(--(YEAR($D$6:$D$11)=$F10))","v":0}]
[null,"Sam Williams","2022-06-06","2023-12-06",null,2029,{"$f":"SUMPRODUCT(--(YEAR($D$6:$D$11)=$F11))","v":0}]

{"sheet":"COUNTIF Current Month","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date",null,"Dates"]
[null,"Robert Hills","2022-08-01","2023-01-01",null,{"$f":"COUNTIFS(D6:D11,\">=\"&EOMONTH(TODAY(),-1)+1,D6:D11,\"<\"&\nEOMONTH(TODAY(),0)+1)","v":2}]
[null,"John Kabir","2022-04-10","2024-12-10"]
[null,"Tom Hanks","2022-01-01","2026-12-01"]
[null,"Manuel jack","2022-05-01","2030-12-01"]
[null,"Austin Cooper","2022-07-05","2023-01-05"]
[null,"Sam Williams","2022-06-06","2023-12-06"]

{"sheet":"COUNTIF Previous Month","index":6,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date",null,"Dates"]
[null,"Robert Hills","2022-08-01","2022-02-02",null,{"$f":"COUNTIFS(D6:D11,\">=\"&EOMONTH(TODAY(),-2)+1,D6:D11,\"<\"&\nEOMONTH(TODAY(),-1)+1)","v":2}]
[null,"John Kabir","2022-04-10","2024-12-10"]
[null,"Tom Hanks","2022-01-01","2022-12-01"]
[null,"Manuel jack","2022-05-01","2030-12-01"]
[null,"Austin Cooper","2022-07-05","2022-01-05"]
[null,"Sam Williams","2022-06-06","2022-12-06"]

{"sheet":"VBA","index":7,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date",null,"Date Count"]
[null,"Robert Hills","2022-08-01","2025-12-01",null,{"$f":"SUM(IF(DateCells(D6:D11)=7,1,0))","v":6}]
[null,"John Kabir","2022-04-10","2024-12-10"]
[null,"Tom Hanks","2022-01-01","2026-12-01"]
[null,"Manuel jack","2022-05-01","2030-12-01"]
[null,"Austin Cooper","2022-07-05","2024-12-05"]
[null,"Sam Williams","2022-06-06","2023-12-06"]

{"sheet":"Practice","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Period of Employment"]
[]
[null,"Employee Name","Joining Date","Leaving Date"]
[null,"Robert Hills","2022-08-01","2025-12-01"]
[null,"John Kabir","2022-04-10","2024-12-10"]
[null,"Tom Hanks","2022-01-01","2026-12-01"]
[null,"Manuel jack","2022-05-01","2030-12-01"]
[null,"Austin Cooper","2022-07-05","2024-12-05"]
[null,"Sam Williams","2022-06-06","2023-12-06"]