{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample","Featured","Today","DAYS","DATEDIF","ABS","Single cell VBA","Range VBA"],"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","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Data Set to Count Days"]
[]
[null,"Dates","Count Days",null,"Today",{"$f":"TODAY()","v":"2022-03-14"}]
[null,"2012-10-11"]
[null,"2012-10-12"]
[null,"2019-11-25"]
[null,"2018-10-03"]
[null,"2016-06-06"]
[null,"2017-12-31"]
[null,"2020-05-13"]

{"sheet":"Featured","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Count Days from Date to Today Automatically"]
[]
[null,"Dates","Today","Formulas","Count Days"]
[null,"2012-10-11",{"$f":"TODAY()","v":"2022-03-14"},"=TODAY()-B5",{"$f":"TODAY()-B5","v":3441}]
[null,"2012-10-12",{"$f":"TODAY()","v":"2022-03-14"},"=DAYS(TODAY(), B6)",{"$f":"_xlfn.DAYS(TODAY(), B6)","v":3440}]
[null,"2022-11-25","2022-03-14","=ABS(TODAY()-B7)",{"$f":"ABS(TODAY()-B7)","v":256}]
[null,"2018-10-03","2022-03-14","=DATEDIF(B8, TODAY(),\"D\")",{"$f":"DATEDIF(B8, TODAY(),\"D\")","v":1258}]

{"sheet":"Today","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply the TODAY Function to Count Days"]
[]
[null,"Dates","Count Days",null,"Today",{"$f":"TODAY()","v":"2022-03-14"}]
[null,"2012-10-11",{"$f":"TODAY()-B5","v":3441}]
[null,"2012-10-12",{"$f":"TODAY()-B6","v":3440}]
[null,"2019-11-25",840]
[null,"2018-10-03",1258]
[null,"2016-06-06",2107]
[null,"2017-12-31",1534]
[null,"2020-05-13",670]

{"sheet":"DAYS","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply the DAYS Function to Count Days"]
[]
[null,"Dates","Count Days",null,"Today",{"$f":"TODAY()","v":"2022-03-14"}]
[null,"2012-10-11",{"$f":"_xlfn.DAYS(TODAY(), B5)","v":3441}]
[null,"2012-10-12",{"$f":"_xlfn.DAYS(TODAY(), B6)","v":3440}]
[null,"2019-11-25",840]
[null,"2018-10-03",1258]
[null,"2016-06-06",2107]
[null,"2017-12-31",1534]
[null,"2020-05-13",670]

{"sheet":"DATEDIF","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply the DATEDIF Function to Count Days"]
[]
[null,"Dates","Count Days",null,"Today",{"$f":"TODAY()","v":"2022-03-14"}]
[null,"2012-10-11",{"$f":"DATEDIF(B5, TODAY(),\"D\")","v":3441}]
[null,"2012-10-12",{"$f":"DATEDIF(B6, TODAY(),\"D\")","v":3440}]
[null,"2019-11-25",840]
[null,"2018-10-03",1258]
[null,"2016-06-06",2107]
[null,"2017-12-31",1534]
[null,"2020-05-13",670]

{"sheet":"ABS","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply the ABS Function to Count Days"]
[]
[null,"Dates","Count Days",null,"Today",{"$f":"TODAY()","v":"2022-03-14"}]
[null,"2012-10-11",{"$f":"ABS(TODAY()-B5)","v":3441}]
[null,"2012-10-12",{"$f":"ABS(TODAY()-B6)","v":3440}]
[null,"2022-11-25",{"$f":"ABS(TODAY()-B7)","v":256}]
[null,"2018-10-03",1258]
[null,"2023-06-06",449]
[null,"2027-12-31",2118]
[null,"2020-05-13",670]

{"sheet":"Single cell VBA","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply a VBA Code For a Single Cell to Count Days"]
[]
[null,"Dates","Today","Count Days"]
[null,"2012-10-11",{"$f":"TODAY()","v":"2022-03-14"},3441]
[null,"2012-10-12",{"$f":"TODAY()","v":"2022-03-14"},3440]
[null,"2022-11-25","2022-03-14",840]
[null,"2018-10-03","2022-03-14",1258]
[null,"2023-06-06","2022-03-14",2107]
[null,"2027-12-31","2022-03-14",1534]
[null,"2020-05-13","2022-03-14",670]

{"sheet":"Range VBA","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Apply a VBA Code For a Range to Count Days"]
[]
[null,"Dates","Today","Unit(days)","Count Days"]
[null,"2012-10-11",{"$f":"TODAY()","v":"2022-03-14"},"d",{"$f":"DATEDIF(B5,C5,D5)","v":3441}]
[null,"2012-10-12",{"$f":"TODAY()","v":"2022-03-14"},"d",{"$f":"DATEDIF(B6,C6,D6)","v":3440}]
[null,"2020-11-25","2022-03-14","d",474]
[null,"2018-10-03","2022-03-14","d",1258]
[null,"2021-06-06","2022-03-14","d",281]
[null,"2017-12-31","2022-03-14","d",1534]
[null,"2020-05-13","2022-03-14","d",670]