Shantanu_4612
New Member
- Joined
- Oct 3, 2016
- Messages
- 27
I am a newbie in vba and I am trying to get in vba all dates between 2 dates, for example I will call the function with the parameters 01-01-2015 and 15-01-2015, and I will get in return an array with all the dates possibles, i.e :
This is the Data that I have;
<tbody>
</tbody>
The Result should be as below, and should stop when finds blanks in start date
<tbody>
</tbody>
Please help me with this its a bit urgent, my job is on stake
This is the Data that I have;
ID | Start Date | End Date | Code |
1234567 | 03-10-2016 | 15-10-2016 | ABC_987654321 |
3456789 | 10-09-2016 | 20-09-2016 | ABC_123456789 |
<tbody>
</tbody>
The Result should be as below, and should stop when finds blanks in start date
ID | Date | Code |
1234567 | 03-10-2016 | ABC_987654321 |
1234567 | 04-10-2016 | ABC_987654321 |
1234567 | 05-10-2016 | ABC_987654321 |
3456789 | 10-09-2016 | ABC_123456789 |
3456789 | 11-09-2016 | ABC_123456789 |
3456789 | 12-09-2016 | ABC_123456789 |
3456789 | 13-09-2016 | ABC_123456789 |
3456789 | 14-09-2016 | ABC_123456789 |
3456789 | 15-09-2016 | ABC_123456789 |
3456789 | 16-09-2016 | ABC_123456789 |
3456789 | 17-09-2016 | ABC_123456789 |
3456789 | 18-09-2016 | ABC_123456789 |
3456789 | 19-09-2016 | ABC_123456789 |
3456789 | 20-09-2016 | ABC_123456789 |
<tbody>
</tbody>
Please help me with this its a bit urgent, my job is on stake