motherindia
Board Regular
- Joined
- Oct 15, 2015
- Messages
- 218
Before Running macro | ||||||||||
The sheeet1 contains following data. I need number of days between 1-4-2014 40 31-3-2019 which should be displayed in shet2 | ||||||||||
Cust ID | St Date | End Date | ||||||||
1 | 01-04-2012 | 30-04-2016 | ||||||||
1 | 01-04-2018 | 30-04-2020 | ||||||||
After running macro sheet2 sould have follong out put | ||||||||||
Years | ||||||||||
01-04-2014 | 01-04-2015 | 01-04-2016 | 01-04-2017 | 01-04-2018 | ||||||
Cust ID | 31-03-2015 | 31-03-2016 | 31-03-2017 | 31-03-2018 | 31-03-2019 | |||||
1 | 365 | 366 | 30 | 0 | 365 |
<colgroup><col><col><col><col span="8"></colgroup><tbody>
</tbody>
Regards,
motherindia