How to calculate between 2 dates by distributing to the months using multiple date entries?

[beginner]

My PBI report graph is is pulling the data from sharepoint library. When there is a case for Lost Work Day the LWD column is populated with the current date. Then whenever the patient's LWD is ended, LWD End date is populated with the date. These columns are text column seperated by ";" when there is a new entry for LWD Start date or LWD End Date. When it is blank then it is populated with ";". I am trying to distrubute these to 12 months and count the number between Start Date and End Date. When there is no end date then it should keep counting but shouldn't exceed the days for the respecting months(Maximum days should be 30/31 depend on every month). I have tried to use split columns and creating measure but it was hard to handle ";".  

https://community.powerbi.com/t5/Desktop/distribution-of-the-number-of-days-per-month-between-2-date... It is very similar to this one. Only addition will be handling multiple start and end dates. 

LWD Start Date | LWD End Date 

;                         | ;                        => Blank (no action needed)

02/02/2022       | ;                        => No end date keep counting

01/01/2022;01/14/2022       | 01/11/2022;01/29/2022 ==> Multiple entries(couint between start dates and end dates)

[amitchandak]

@beginner , refer HR example can help

Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

You need to add distribution logic based on selected date and start date

[beginner]

Thank you.It helps however it is not really helping with handling multiple date entries in the same column. I think solution I have posted also was helpful but I can't find to handle multiple date records in the same column. Splitting helped but not resolving the issue.