{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","COUNTIF","SUMPRODUCT","PivotTable","Sheet5","Dataset 2","COUNTIFS","SUMPRODUCT2","VBA Dataset","VBA","Unique Occ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Date Occurences of a Particular Date"]
[]
[null,"Book Title","Date of Publication"]
[null,"The Transvaal","02-May-1877"]
[null,"A Zulu War-Dance","17-Jul-1877"]
[null,"A Visit to the Chief Secocoeni","17-Jul-1878"]
[null,"Hydrophobia","3-Nov-1885"]
[null,"The Land Question","28-Apr-1886"]
[null,"About Fiction","02-Feb-1887"]
[null,"Mr Rider Haggard and His Critics","27-Apr-1887"]
[null,"American Copyright","27-Apr-1888"]
[null,"Delagoa Bay","17-Dec-1887"]
[null,"Mr. Meeson's Will","18-Jan-1888"]
[null,"The Wreck of the Copeland","18-Aug-1888"]
[null,"Cleopatra","17-Jul-1877"]
[null,"Virgin of the Sun","3-Nov-1885"]
[null,"The Fate of Swaziland","12-Jun-1892"]
[null,"Alan and the Holy Flower","27-Apr-1888"]
[null,"Nada the Lily","3-Nov-1885"]
[null,"She","13-Feb-1887"]
[null,"And Return of She","13-Feb-1888"]
[null,"The People of the Mist","18-Aug-1888"]
[null,"Heart of the World","18-Aug-1888"]

{"sheet":"COUNTIF","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using COUNTIF Function"]
[]
[null,"Book Title","Date of Publication",null,"Books published in 18 Aug, 1888"]
[null,"The Transvaal","02-May-1877",null,{"$f":"COUNTIF(C5:C243,\"18-Aug-1888\")","v":3}]
[null,"A Zulu War-Dance","17-Jul-1877"]
[null,"A Visit to the Chief Secocoeni","17-Jul-1878"]
[null,"Hydrophobia","3-Nov-1885"]
[null,"The Land Question","28-Apr-1886"]
[null,"About Fiction","02-Feb-1887"]
[null,"Mr Rider Haggard and His Critics","27-Apr-1887"]
[null,"American Copyright","27-Apr-1888"]
[null,"Delagoa Bay","17-Dec-1887"]
[null,"Mr. Meeson's Will","18-Jan-1888"]
[null,"The Wreck of the Copeland","18-Aug-1888"]
[null,"Cleopatra","17-Jul-1877"]
[null,"Virgin of the Sun","3-Nov-1885"]
[null,"The Fate of Swaziland","12-Jun-1892"]
[null,"Alan and the Holy Flower","27-Apr-1888"]
[null,"Nada the Lily","3-Nov-1885"]
[null,"She","13-Feb-1887"]
[null,"And Return of She","13-Feb-1888"]
[null,"The People of the Mist","18-Aug-1888"]
[null,"Heart of the World","18-Aug-1888"]

{"sheet":"SUMPRODUCT","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUMPRODUCT Function"]
[]
[null,"Book Title","Date of Publication",null,"Books published in 18 Aug, 1888"]
[null,"The Transvaal","02-May-1877",null,{"$f":"SUMPRODUCT(--(C5:C25=\"18-Aug-1888\"))","v":3}]
[null,"A Zulu War-Dance","17-Jul-1877"]
[null,"A Visit to the Chief Secocoeni","17-Jul-1878"]
[null,"Hydrophobia","3-Nov-1885"]
[null,"The Land Question","28-Apr-1886"]
[null,"About Fiction","02-Feb-1887"]
[null,"Mr Rider Haggard and His Critics","27-Apr-1887"]
[null,"American Copyright","27-Apr-1888"]
[null,"Delagoa Bay","17-Dec-1887"]
[null,"Mr. Meeson's Will","18-Jan-1888"]
[null,"The Wreck of the Copeland","18-Aug-1888"]
[null,"Cleopatra","17-Jul-1877"]
[null,"Virgin of the Sun","3-Nov-1885"]
[null,"The Fate of Swaziland","12-Jun-1892"]
[null,"Alan and the Holy Flower","27-Apr-1888"]
[null,"Nada the Lily","3-Nov-1885"]
[null,"She","13-Feb-1887"]
[null,"And Return of She","13-Feb-1888"]
[null,"The People of the Mist","18-Aug-1888"]
[null,"Heart of the World","18-Aug-1888"]

{"sheet":"PivotTable","index":3,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Pivot Table"]
[]
[null,"Book Title","Date of Publication"]
[null,"The Transvaal","02-May-1877"]
[null,"A Zulu War-Dance","17-Jul-1877"]
[null,"A Visit to the Chief Secocoeni","17-Jul-1878"]
[null,"Hydrophobia","3-Nov-1885"]
[null,"The Land Question","28-Apr-1886"]
[null,"About Fiction","02-Feb-1887"]
[null,"Mr Rider Haggard and His Critics","27-Apr-1887"]
[null,"American Copyright","27-Apr-1888"]
[null,"Delagoa Bay","17-Dec-1887"]
[null,"Mr. Meeson's Will","18-Jan-1888"]
[null,"The Wreck of the Copeland","18-Aug-1888"]
[null,"Cleopatra","17-Jul-1877"]
[null,"Virgin of the Sun","3-Nov-1885"]
[null,"The Fate of Swaziland","12-Jun-1892"]
[null,"Alan and the Holy Flower","27-Apr-1888"]
[null,"Nada the Lily","3-Nov-1885"]
[null,"She","13-Feb-1887"]
[null,"And Return of She","13-Feb-1888"]
[null,"The People of the Mist","18-Aug-1888"]
[null,"Heart of the World","18-Aug-1888"]

{"sheet":"Sheet5","index":4,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Count of Date of Publication"]
["02-Feb-1887",1]
["02-May-1877",1]
["12-Jun-1892",1]
["13-Feb-1887",1]
["13-Feb-1888",1]
["17-Dec-1887",1]
["17-Jul-1877",2]
["17-Jul-1878",1]
["18-Aug-1888",3]
["18-Jan-1888",1]
["27-Apr-1887",1]
["27-Apr-1888",2]
["28-Apr-1886",1]
["3-Nov-1885",3]
["Grand Total",20]

{"sheet":"Dataset 2","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Total Number of Dates in a Particular Range"]
[]
[null,"Book Title","Date of Publication"]
[null,1984,"1949-06-08"]
[null,"To Kill a Mockingbird","1960-07-11"]
[null,"One Hundred Yeards of Solitude","1967-05-05"]
[null,"The Great Gatsby","1925-04-10"]
[null,"Animal Farm","1945-08-17"]
[null,"The Grapes of Wrath","1939-04-14"]
[null,"The Hobbit","1989-09-21"]
[null,"The Little Prince","1943-04-06"]
[null,"Fahrenheit 451","1953-10-19"]
[null,"The Catcher in the Rye","1951-07-16"]
[null,"The Trial","1925-04-26"]
[null,"Lord of the Flies","1954-09-17"]
[null,"Gone with the Wind","1936-06-30"]

{"sheet":"COUNTIFS","index":6,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using COUNTIFS Function"]
[]
[null,"Book Title","Date of Publication",null,"Books"]
[null,1984,"1949-06-08",null,{"$f":"COUNTIFS(C5:C17,\">1/1/1940\",C5:C17,\"<=12/31/1950\")","v":3}]
[null,"To Kill a Mockingbird","1960-07-11"]
[null,"One Hundred Yeards of Solitude","1967-05-05"]
[null,"The Great Gatsby","1925-04-10"]
[null,"Animal Farm","1945-08-17"]
[null,"The Grapes of Wrath","1939-04-14"]
[null,"The Hobbit","1989-09-21"]
[null,"The Little Prince","1943-04-06"]
[null,"Fahrenheit 451","1953-10-19"]
[null,"The Catcher in the Rye","1951-07-16"]
[null,"The Trial","1925-04-26"]
[null,"Lord of the Flies","1954-09-17"]
[null,"Gone with the Wind","1936-06-30"]

{"sheet":"SUMPRODUCT2","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUMPRODUCT Function"]
[]
[null,"Book Title","Date of Publication",null,"Books"]
[null,1984,"1949-06-08",null,{"$f":"SUMPRODUCT(((C5:C17)>=DATE(1940,1,1))*((C5:C17)<=DATE(1950,12,31)))","v":3}]
[null,"To Kill a Mockingbird","1960-07-11"]
[null,"One Hundred Yeards of Solitude","1967-05-05"]
[null,"The Great Gatsby","1925-04-10"]
[null,"Animal Farm","1945-08-17"]
[null,"The Grapes of Wrath","1939-04-14"]
[null,"The Hobbit","1989-09-21"]
[null,"The Little Prince","1943-04-06"]
[null,"Fahrenheit 451","1953-10-19"]
[null,"The Catcher in the Rye","1951-07-16"]
[null,"The Trial","1925-04-26"]
[null,"Lord of the Flies","1954-09-17"]
[null,"Gone with the Wind","1936-06-30"]

{"sheet":"VBA Dataset","index":8,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA"]
[]
[null,"Book Title","Starting Date","Finishing Date"]
[null,"The Transvaal","1977-05-02",{"$f":"DATE(78,2,3)","v":"1978-02-03"}]
[null,"A Zulu War-Dance","1977-07-17",{"$f":"DATE(79,5,11)","v":"1979-05-11"}]
[null,"A Visit to the Chief Secocoeni","1977-07-17",{"$f":"DATE(86,7,3)","v":"1986-07-03"}]
[null,"Hydrophobia","1978-11-03",{"$f":"DATE(81,9,11)","v":"1981-09-11"}]
[null,"The Land Question","1985-04-28",{"$f":"DATE(87,2,3)","v":"1987-02-03"}]
[null,"About Fiction","1986-02-02",{"$f":"DATE(87,5,11)","v":"1987-05-11"}]
[null,"Mr Rider Haggard and His Critics","1987-04-27",{"$f":"DATE(90,2,7)","v":"1990-02-07"}]
[null,"American Copyright","1989-05-12",{"$f":"DATE(89,5,12)","v":"1989-05-12"}]
[null,"Delagoa Bay","1987-01-18",{"$f":"DATE(93,2,3)","v":"1993-02-03"}]
[null,"Mr. Meeson's Will","1988-08-18",{"$f":"DATE(89,5,11)","v":"1989-05-11"}]
[null,"The Wreck of the Copeland","1988-07-17",{"$f":"DATE(88,12,11)","v":"1988-12-11"}]
[null,"Cleopatra","1977-11-03",{"$f":"DATE(79,10,11)","v":"1979-10-11"}]
[null,"Virgin of the Sun","1985-06-12",{"$f":"DATE(90,3,3)","v":"1990-03-03"}]
[null,"The Fate of Swaziland","1992-06-12",{"$f":"DATE(96,5,11)","v":"1996-05-11"}]
[null,"Alan and the Holy Flower","1988-04-27",{"$f":"DATE(98,5,11)","v":"1998-05-11"}]
[null,"Nada the Lily","1985-11-03",{"$f":"DATE(89,5,11)","v":"1989-05-11"}]
[null,"She","1987-02-13",{"$f":"DATE(90,5,11)","v":"1990-05-11"}]
[null,"And Return of She","1988-02-13",{"$f":"DATE(89,5,#REF!)","v":{"$error":"#REF!"}}]
[null,"The People of the Mist","1988-08-18",{"$f":"DATE(91,5,11)","v":"1991-05-11"}]
[null,"Heart of the World","1988-08-18",{"$f":"DATE(90,5,11)","v":"1990-05-11"}]

{"sheet":"VBA","index":9,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA"]
[]
[null,"Book Title","Starting Date","Finishing Date",null,"Result"]
[null,"The Transvaal","1977-05-02",{"$f":"DATE(78,2,3)","v":"1978-02-03"},null,{"$f":"CountFor(DATE(90,1,1),C5:D24)","v":7}]
[null,"A Zulu War-Dance","1977-07-17",{"$f":"DATE(79,5,11)","v":"1979-05-11"}]
[null,"A Visit to the Chief Secocoeni","1977-07-17",{"$f":"DATE(86,7,3)","v":"1986-07-03"}]
[null,"Hydrophobia","1978-11-03",{"$f":"DATE(81,9,11)","v":"1981-09-11"}]
[null,"The Land Question","1985-04-28",{"$f":"DATE(87,2,3)","v":"1987-02-03"}]
[null,"About Fiction","1986-02-02",{"$f":"DATE(87,5,11)","v":"1987-05-11"}]
[null,"Mr Rider Haggard and His Critics","1987-04-27",{"$f":"DATE(90,2,7)","v":"1990-02-07"}]
[null,"American Copyright","1989-05-12",{"$f":"DATE(89,5,12)","v":"1989-05-12"}]
[null,"Delagoa Bay","1987-01-18",{"$f":"DATE(93,2,3)","v":"1993-02-03"}]
[null,"Mr. Meeson's Will","1988-08-18",{"$f":"DATE(89,5,11)","v":"1989-05-11"}]
[null,"The Wreck of the Copeland","1988-07-17",{"$f":"DATE(88,12,11)","v":"1988-12-11"}]
[null,"Cleopatra","1977-11-03",{"$f":"DATE(79,10,11)","v":"1979-10-11"}]
[null,"Virgin of the Sun","1985-06-12",{"$f":"DATE(90,3,3)","v":"1990-03-03"}]
[null,"The Fate of Swaziland","1992-06-12",{"$f":"DATE(96,5,11)","v":"1996-05-11"}]
[null,"Alan and the Holy Flower","1988-04-27",{"$f":"DATE(98,5,11)","v":"1998-05-11"}]
[null,"Nada the Lily","1985-11-03",{"$f":"DATE(89,5,11)","v":"1989-05-11"}]
[null,"She","1987-02-13",{"$f":"DATE(90,5,11)","v":"1990-05-11"}]
[null,"And Return of She","1988-02-13",{"$f":"DATE(89,5,F2012)","v":"1989-04-30"}]
[null,"The People of the Mist","1988-08-18",{"$f":"DATE(91,5,11)","v":"1991-05-11"}]
[null,"Heart of the World","1988-08-18",{"$f":"DATE(90,5,11)","v":"1990-05-11"}]

{"sheet":"Unique Occ","index":10,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Counting Unique Date Occurences"]
[]
[null,"Name","Birthday",null,"Dates","Count"]
[null,"Melissa","1990-08-15",null,{"$f":"_xlfn.UNIQUE(C5:C17)","v":"1990-08-15"},{"$f":"COUNTIF($C$5:$C$17,E5)","v":4}]
[null,"Elizabeth","1990-08-15",null,"1990-08-20",{"$f":"COUNTIF($C$5:$C$17,E6)","v":3}]
[null,"Stephanie","1990-08-20",null,"1992-09-05",2]
[null,"Larry","1992-09-05",null,"1991-09-05",1]
[null,"Rachel","1991-09-05",null,"1992-09-15",1]
[null,"Evelyn","1990-08-15",null,"1990-09-05",1]
[null,"Julia","1992-09-15",null,"1991-09-20",1]
[null,"Philip","1992-09-05"]
[null,"Harris","1990-09-05"]
[null,"Jessica","1990-08-20"]
[null,"Diane","1991-09-20"]
[null,"Julie","1990-08-15"]
[null,"Ann","1990-08-20"]