Hi.
I have a dataset that contains instances of staff holidays. However, depending on how each manager has put the holiday on the system, the row can show individual days for a holiday period or some show the date range. I am aiming to count each instance a member of staff has thus in the below example, there are only 3 instances however there are 5 rows. Is there a way to group dates that are in succession of each other to be able to count the number of instances for each staff member?
Start Date | End Date | No of Days
15/2/2019 | 15/2/2019 | 1
16/2/2019 | 16/2/2019 | 1
17/2/2019 | 17/2/2019 | 1
19/2/2019 | 19/2/2019 | 1
20/3/2019 | 24/3/2019 | 5
Any help with this would be greatly appreciated.
Bookmarks