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.
[TABLE="width: 602"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Date taken[/TD]
[TD]Date returned[/TD]
[/TR]
[TR]
[TD]X1[/TD]
[TD]XX[/TD]
[TD]16/11/2017[/TD]
[TD]31/12/2017[/TD]
[/TR]
[TR]
[TD]X2[/TD]
[TD]YY[/TD]
[TD]1/1/2018[/TD]
[TD]15/5/2018[/TD]
[/TR]
</tbody>[/TABLE]


From that table, I need to derive number of days for each ID & Name by monthly basis. The table is like below:
[TABLE="width: 188"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
[TR]
[TD]1/1/2017[/TD]
[TD]31/1/2017[/TD]
[/TR]
[TR]
[TD]31/1/2017[/TD]
[TD]28/2/2017[/TD]
[/TR]
[TR]
[TD]28/2/2017[/TD]
[TD]31/3/2017[/TD]
[/TR]
</tbody>[/TABLE]


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.