Summarizing date table to monthly closing

[pakdin]

I have a table with four columns (ID, Date Taken, Date Return, Amount). The Date Taken & Date Return column only closed yearly.

ID	Name	Date taken	Date returned
X1	XX	16/11/2017	31/12/2017
X2	YY	1/1/2018	15/5/2018

<tbody>
</tbody>

From that table, I need to derive number of days for each ID & Name by monthly basis. The table is like below:

Start Date	End Date
1/1/2017	31/1/2017
31/1/2017	28/2/2017
28/2/2017	31/3/2017

<tbody>
</tbody>

I could derived the monthly basis table by only single line item. If i want to incorporate the second column, i need to manually add the initial formula. I use IF function.

Please help

 

[Panda514]

Hello,

Will you explain how the Start Date and End Date correlate with the Data Taken and Date Returned? For example, I'm not sure how the Date Taken of 16/11/2017 make a start date of 1/1/2017.