I have thousands of rows of client enrollments, enrollments can range from one day to multiple months and are tracked with an entry an exit date. My goal is to take this enrollment data and output the number of unique clients and the total number of enrollment days per complete month. So if a single client's start date was 2020-09-15 and their exit was 2020-11-15, the output should be:
Enrollment Days:
2020-09: 15 enrollment days
2020-10: 31 enrollment days
2020-11: 15 enrollment days
Is this possible?
