Summarizing date table to monthly closing

pakdin

New Member
Joined
Mar 10, 2019
Messages
1
I have a table with four columns (ID, Date Taken, Date Return, Amount). The Date Taken & Date Return column only closed yearly.
IDNameDate takenDate returned
X1XX16/11/201731/12/2017
X2YY1/1/201815/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 DateEnd Date
1/1/201731/1/2017
31/1/201728/2/2017
28/2/201731/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
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Panda514

New Member
Joined
Mar 11, 2019
Messages
37
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,956
Messages
5,525,884
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top