Hi all.
I have one query about filling up the date if few criteria are fulfilled. Table is as follow;
<tbody>
</tbody>
Range C2:I7 should be filled up with formula.
Please help.
Thanking you all in advance
I have one query about filling up the date if few criteria are fulfilled. Table is as follow;
A | B | C | D | E | F | G | H | I | |
1 | Buy Date | Maturity Date | 31-03-16 | 31-03-17 | 31-03-18 | 31-03-19 | 31-03-20 | 31-03-21 | 31-03-22 |
2 | 12/09/17 | 15/09/20 | 15/09/17 | 15/09/18 | 15/09/19 | 15/09/20 | |||
3 | 12/09/17 | 05/09/20 | 05/09/18 | 05/09/19 | 05/09/20 | ||||
4 | 10/09/17 | 25/10/20 | 25/10/17 | 25/10/18 | 25/10/19 | 25/10/20 | |||
5 | 10/09/17 | 05/10/20 | 05/10/17 | 05/10/19 | 05/10/19 | 05/10/20 | |||
6 | 18/09/17 | 12/08/20 | 12/08/18 | 12/08/19 | 12/08/20 | ||||
7 | 18/09/17 | 22/08/20 | 22/08/18 | 22/08/19 | 22/08/20 |
<tbody>
</tbody>
Range C2:I7 should be filled up with formula.
Please help.
Thanking you all in advance