I have a scenario where number of days between start and end date excluding weekends has to be calculated for each person in the data set.
The calculation is a bit straightforward for those who have only one record or row in the dataset but more complicated when an individual has more than one record in the dataset.
I need help with the total number of days calculation for those with multiple start and end dates in the same month and would prefer the calculation to sum all their records as one even though they appear more than once.
Attached is an illustration of the dataset:
Off_Time.xlsx (16.1 KB)