I have a conundrum. I am using the Networkdays formula with a start date of 8/28/2018 and an end date of 6/18/2019 with the following holiday serial dates (n=28): =NETWORKDAYS(G1,H1,B3:B30)
43346
43353
43362
43381
43416
43425
43426
43427
43458
43459
43460
43461
43462
43465
43466
43486
43514
43515
43516
43517
43518
43528
43570
43571
43572
43573
43574
43612
I am then using the same formula with the same start and end dates with the following holiday serial dates (n=30): =NETWORKDAYS(G1,H1,B3:B32)
43708
43346
43353
43362
43381
43775
43416
43425
43426
43427
43458
43459
43460
43461
43462
43465
43466
43486
43514
43515
43516
43517
43518
43528
43570
43571
43572
43573
43574
43612
The issue I am having is they are both giving me the same count of 183.
What am I missing?
43346
43353
43362
43381
43416
43425
43426
43427
43458
43459
43460
43461
43462
43465
43466
43486
43514
43515
43516
43517
43518
43528
43570
43571
43572
43573
43574
43612
I am then using the same formula with the same start and end dates with the following holiday serial dates (n=30): =NETWORKDAYS(G1,H1,B3:B32)
43708
43346
43353
43362
43381
43775
43416
43425
43426
43427
43458
43459
43460
43461
43462
43465
43466
43486
43514
43515
43516
43517
43518
43528
43570
43571
43572
43573
43574
43612
The issue I am having is they are both giving me the same count of 183.
What am I missing?