earthworm
Well-known Member
- Joined
- May 19, 2009
- Messages
- 759
- Office Version
- 2019
- 2016
- Platform
- Windows
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.
<colgroup><col width="127" style="width:95pt" span="2"> </colgroup><tbody>
</tbody>
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>