{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Overview","Excluding Weekends","Weekend+Holiday","TODAY","Hours","Average","VBA","NETWORKDAYS.INTL","Not Working"],"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":"Overview","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Overview of NETWORKDAYS Function"]
[]
[null,"Start Date","End Date","Total Days","Excluding Weekends"]
[null,"2021-01-06","2021-05-07",{"$f":"_xlfn.DAYS(C5,B5)","v":121},{"$f":"NETWORKDAYS(B5,C5)","v":88},"  =NETWORKDAYS(B5,C5)"]
[null,"2020-07-05","2021-03-06",{"$f":"_xlfn.DAYS(C6,B6)","v":244},{"$f":"NETWORKDAYS(B6,C6)","v":175},"  =NETWORKDAYS(B6,C6)"]
[null,"2021-02-28","2021-08-01",154,110,"  =NETWORKDAYS(B7,C7)"]
[]
[null,null,"Holidays",null,"Excluding Weekeends & Holidays"]
[null,null,"2021-01-01",null,{"$f":"NETWORKDAYS(B5,C5,$C$10:$C$18)","v":87},"  =NETWORKDAYS(B5,C5,$C$10:$C$18)"]
[null,null,"2021-01-18",null,{"$f":"NETWORKDAYS(B6,C6,$C$10:$C$18)","v":173},"  =NETWORKDAYS(B6,C6,$C$10:$C$18)"]
[null,null,"2021-05-31",null,108,"  =NETWORKDAYS(B7,C7,$C$10:$C$18)"]
[null,null,"2021-07-05"]
[null,null,"2021-09-06"]
[null,null,"2021-11-11"]
[null,null,"2021-11-25"]
[null,null,"2021-12-24"]
[null,null,"2021-12-31"]

{"sheet":"Excluding Weekends","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NETWORKDAYS to Exclude Weekends Only"]
[]
[null,"Start Date","End Date","Total Days Between Dates","Excluding Weekends"]
[null,"2021-01-06","2021-05-07",{"$f":"_xlfn.DAYS(C5,B5)","v":121},{"$f":"NETWORKDAYS(B5,C5)","v":88}]
[null,"2020-07-05","2021-03-06",{"$f":"_xlfn.DAYS(C6,B6)","v":244},{"$f":"NETWORKDAYS(B6,C6)","v":175}]
[null,"2021-02-28","2021-08-01",{"$f":"_xlfn.DAYS(C7,B7)","v":154},{"$f":"NETWORKDAYS(B7,C7)","v":110}]
[]
[]
[null,null,null,"=DAYS(end_date, start_date)"]

{"sheet":"Weekend+Holiday","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NETWORKDAYS to Exclude Both Weekends & Holidays"]
[]
[null,"Start Date","End Date","Total Days","Excluding Weekends & Holidays"]
[null,"2021-01-06","2021-05-07",{"$f":"_xlfn.DAYS(C5,B5)","v":121},{"$f":"NETWORKDAYS(B5,C5,$D$10:$D$18)","v":87}]
[null,"2020-07-05","2021-03-06",{"$f":"_xlfn.DAYS(C6,B6)","v":244},{"$f":"NETWORKDAYS(B6,C6,$D$10:$D$18)","v":173}]
[null,"2021-02-28","2021-08-01",154,108]
[]
[null,null,null,"Holidays"]
[null,null,null,"2021-01-01"]
[null,null,null,"2021-01-18"]
[null,null,null,"2021-05-31"]
[null,null,null,"2021-07-05"]
[null,null,null,"2021-09-06"]
[null,null,null,"2021-11-11"]
[null,null,null,"2021-11-25"]
[null,null,null,"2021-12-24"]
[null,null,null,"2021-12-31"]

{"sheet":"TODAY","index":3,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,6,1]]}
[]
[null,"NETWORKDAYS Formula with TODAY Function"]
[]
[null,"Start Date","End Date","Excluding Weekends & Holidays"]
[null,"Today's date","2023-05-07",{"$f":"NETWORKDAYS(TODAY(),C5,$D$10:$D$18)","v":15}]
[null,null,"2023-07-06",{"$f":"NETWORKDAYS(TODAY(),C6,$D$10:$D$18)","v":57}]
[null,null,"2023-06-01",33]
[]
[null,null,null,"Holidays"]
[null,null,null,"2023-01-01"]
[null,null,null,"2023-01-18"]
[null,null,null,"2023-05-31"]
[null,null,null,"2023-07-05"]
[null,null,null,"2023-09-06"]
[null,null,null,"2023-11-11"]
[null,null,null,"2023-11-25"]
[null,null,null,"2023-12-24"]
[null,null,null,"2023-12-31"]

{"sheet":"Hours","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,3,6,3],[1,1,1,4]]}
[]
[null,"Calculating Net Working Hours"]
[]
[null,"Start Date","End Date","Working Hours Per Day","Net Working Hours"]
[null,"2021-01-06","2021-05-07",8,{"$f":"NETWORKDAYS(B5,C5,$D$10:$D$18)*$D$5","v":696}]
[null,"2020-07-05","2021-03-06",null,{"$f":"NETWORKDAYS(B6,C6,$D$10:$D$18)*$D$5","v":1384}]
[null,"2021-02-28","2021-08-01",null,864]
[]
[null,null,null,"Holidays"]
[null,null,null,"2021-01-01"]
[null,null,null,"2021-01-18"]
[null,null,null,"2021-05-31"]
[null,null,null,"2021-07-05"]
[null,null,null,"2021-09-06"]
[null,null,null,"2021-11-11"]
[null,null,null,"2021-11-25"]
[null,null,null,"2021-12-24"]
[null,null,null,"2021-12-31"]

{"sheet":"Average","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Average Working Days Per Month"]
[]
[null,"Start Date","End Date","Net Working Days"]
[null,"2021-01-06","2021-05-06",{"$f":"NETWORKDAYS(B5,C5,$D$10:$D$18)/DATEDIF(B5,C5,\"M\")","v":21.5}]
[null,"2020-07-13","2021-03-13",{"$f":"NETWORKDAYS(B6,C6,$D$10:$D$18)/DATEDIF(B6,C6,\"M\")","v":21.625}]
[null,"2021-02-28","2021-08-28",21.333333333333332]
[]
[null,null,null,"Holidays"]
[null,null,null,"2021-01-01"]
[null,null,null,"2021-01-18"]
[null,null,null,"2021-05-31"]
[null,null,null,"2021-07-05"]
[null,null,null,"2021-09-06"]
[null,null,null,"2021-11-11"]
[null,null,null,"2021-11-25"]
[null,null,null,"2021-12-24"]
[null,null,null,"2021-12-31"]

{"sheet":"VBA","index":6,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"NETWORKDAYS Function in VBA Macro"]
[]
[null,"Start Date","End Date","Excluding Weekends & Holidays"]
[null,"2021-01-06","2021-05-07",87]
[null,"2020-07-05","2021-03-06",173]
[null,"2021-02-28","2021-08-01",108]
[]
[null,null,null,"Holidays"]
[null,null,null,"2021-01-01"]
[null,null,null,"2021-01-18"]
[null,null,null,"2021-05-31"]
[null,null,null,"2021-07-05"]
[null,null,null,"2021-09-06"]
[null,null,null,"2021-11-11"]
[null,null,null,"2021-11-25"]
[null,null,null,"2021-12-24"]
[null,null,null,"2021-12-31"]

{"sheet":"NETWORKDAYS.INTL","index":7,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NETWORKDAYS to Exclude Both Weekends & Holidays"]
[]
[null,"Start Date","End Date","Total Days","Excluding Weekends & Holidays"]
[null,"2021-01-06","2021-05-07",{"$f":"_xlfn.DAYS(C5,B5)","v":121},{"$f":"NETWORKDAYS.INTL(B5,C5,7,$E$10:$E$18)","v":86}]
[null,"2020-07-05","2021-03-06",{"$f":"_xlfn.DAYS(C6,B6)","v":244},{"$f":"NETWORKDAYS.INTL(B6,C6,7,$E$10:$E$18)","v":174}]
[null,"2021-02-28","2021-08-01",154,109]
[]
[null,"Index","Weekend",null,"Holidays"]
[null,1,"Satursday, Sunday",null,"2021-01-01"]
[null,2,"Sunday, Monday",null,"2021-01-18"]
[null,3,"Monday, Tuesday",null,"2021-05-31"]
[null,4,"Tuesday, Wednesday",null,"2021-07-05"]
[null,5,"Wednesday, Thursday",null,"2021-09-06"]
[null,6,"Thursday, Friday",null,"2021-11-11"]
[null,7,"Friday, Saturday",null,"2021-11-25"]
[null,11,"Sunday Only",null,"2021-12-24"]
[null,12,"Monday Only",null,"2021-12-31"]
[null,13,"Tuesday Only"]
[null,14,"Wednesday Only"]
[null,15,"Thursday Only"]
[null,16,"Friday Only"]
[null,17,"Saturday Only"]

{"sheet":"Not Working","index":8,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"NETWORKDAYS Formula Is Not Working"]
[]
[null,"Start Date","End Date","Excluding Weekends & Holidays"]
[null,"2021-01-06","2021-07-25",{"$f":"NETWORKDAYS(B5,C5,$D$10:$D$18)","v":140}]
[null,"2020-05-27","2021-03-06",{"$f":"NETWORKDAYS(B6,C6,$D$10:$D$18)","v":201}]
[null,"2021-02-28","2021-04-18",35]
[]
[null,null,null,"Holidays"]
[null,null,null,"2021-01-01"]
[null,null,null,"2021-01-18"]
[null,null,null,"2021-05-31"]
[null,null,null,"2021-07-05"]
[null,null,null,"2021-09-06"]
[null,null,null,"2021-11-11"]
[null,null,null,"2021-11-25"]
[null,null,null,"2021-12-24"]
[null,null,null,"2021-12-31"]