Hi all,
I need to generate date series in columnar form for many of Bond series from the date of purchase till Maturity date.
I do not want to use fill handle as for all bond series i can not use. Following is the required sheet;
<tbody>
</tbody>
please help me to generate formula from year 1 onward column.
Thankng you in advance.
I need to generate date series in columnar form for many of Bond series from the date of purchase till Maturity date.
I do not want to use fill handle as for all bond series i can not use. Following is the required sheet;
Name | Buy Date | Maturity Date | Year Left | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 |
Series1 | 30/04/2018 | 25/10/2023 | 5 | 25/10/18 | 25/10/19 | 25/10/20 | 25/10/21 | 25/10/22 | 25/10/23 | ||
Series2 | 31/01/2016 | 13/01/2024 | 8 | 13/01/17 | 13/01/18 | 13/01/19 | 13/01/20 | 13/01/21 | 13/01/22 | 13/01/23 | 13/01/24 |
Series3 | 25/09/2015 | 25/12/2022 | 7 | 25/12/15 | 25/12/16 | 25/12/17 | 25/12/18 | 25/12/19 | 25/12/20 | 25/12/21 | 25/12/22 |
<tbody>
</tbody>
please help me to generate formula from year 1 onward column.
Thankng you in advance.