I have a list of time off requests that are listed as date ranges (ie. 6/7/21 - 6/10/21 ) and I need to make a count of how many days off are requested for each date, ideally without having to manually input each date between the date ranges. So i want to be able to input
6/7/21 - 6/10/21
6/8/21 - 6/8/21
6/8/21 - 6/9/21
and be able to get a list
6/7/21 - 1
6/8/21 - 3
6/9/21 - 2
6/10/21 1
6/7/21 - 6/10/21
6/8/21 - 6/8/21
6/8/21 - 6/9/21
and be able to get a list
6/7/21 - 1
6/8/21 - 3
6/9/21 - 2
6/10/21 1