Seeded Setup Leave Split Leave Monthly wise

There is a setup called sick Leave .Here Client want if user applied long Service leave then after approved or next page leave must separate monthly wise and same month wise element entry and absence entry entered into database.

Example:- Sick Leave

Start Date: 03-Nov-2020

End Date: 22-Feb-2021

Duration: 111 Days

 Start Date        End Date        Duration

3-Nov-2020       30-Nov-2020       27

1-Dec-2020       31-Dec-2020       31

1-Jan-2021        31-Jan-2021       31

1-Feb-2021        22-Feb-2021      22

So, Please let me know how to achieve this requirement.