Hello all,
I have multiple date ranges, the start and end date are in different columns (say B and C).
Example:
2/10-2/12
2/11-2/14
2/18-2/21
So to some extent I was using networkdays with min from the column B range and max from column C range, but while that avoids double counting the overlap between 2/10 to 2/12 and 2/11 to 2/14, it counts the gap between 2/14 to 2/18, which I need it to not do. On the other hand, if I do networkdays for each and sum them, I end up counting overlap days more than once.
Thank you in advance for any tips and suggestions.
Bookmarks