Create a Table between two dates

[earthworm]

I want to create a table of Date between two dates . I tired to apply many logic but I am stuck when the maturity date goes on 9th Nov-2016 and then restarting the dates from 9th November-2016

Start Date : 9 May-2016
Tenor : 6 Months.

Below is the result i want highlighted in red.

Tenor	6 Months
Start Date	Maturity Date
9-May-16	31-May-16
1-Jun-16	30-Jun-16
1-Jul-16	31-Jul-16
1-Aug-16	31-Aug-16
1-Sep-16	30-Sep-16
1-Oct-16	31-Oct-16
1-Nov-16	9-Nov-16
10-Nov-16	30-Nov-16
1-Dec-16	31-Dec-16
1-Jan-17	31-Jan-17
1-Feb-17	28-Feb-17
1-Mar-17	31-Mar-17
1-Apr-17	30-Apr-17
1-May-17	9-May-17
10-May-17	31-May-17
1-Jun-17	30-Jun-17
1-Jul-17	31-Jul-17
1-Aug-17	31-Aug-17
1-Sep-17	30-Sep-17

<colgroup><col width="127" style="width:95pt" span="2"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

1-Oct-16	31-Oct-16
1-Nov-16	9-Nov-16
10-Nov-16	30-Nov-16
1-Dec-16	31-Dec-16

<tbody>
</tbody>

you have mainly the first and last day in the month
why did you change to 1 nov 16 through to 9 nov 16
given that you did - is the rule the next row is 9 nov 16 plus 1 = 10 nov 16 to the end of the month

 

[earthworm]

It's a fixed deposit of 6 months.In each month I need to apply different rates. I need to show customer for how.may days his deposit has been booked , matures after each month and what is the history of his next reinvestment . Hence to create a complete trail.

 

[earthworm]

On each month the rate changes and I need to show a trail of fixed deposit. What was the last day the deposit matured and after reinvestment what is the new trail /history

 

[earthworm]

It's dynamic trail that will show for how long fund has been kept and from which date it has been reinvested. I need to break each month seperately because there are different rates each month

 

[Tetra201]

Try these:

cell B3 (and drag-copy down) =MIN(EOMONTH($A3,0),EDATE($A$3,ROUNDUP((ROWS($A$3:$A3))/7,0)*6))
cell A4 (and drag-copy down) =B3+1

 

[earthworm]

Try these:

cell B3 (and drag-copy down) =MIN(EOMONTH($A3,0),EDATE($A$3,ROUNDUP((ROWS($A$3:$A3))/7,0)*6))
cell A4 (and drag-copy down) =B3+1

Amazing . Can you please explain the logic behind bold parts

 

[earthworm]

ahhh your formula has one issue . Its dependent on column of "Maturity Date" . I want to appear these date to appear only if i input the start date . Entire thing must be dependent on start date only.