I need a VBA in column F that grabs dates from every third column starting from I, L, O, and so on.
Columns I, L, O, etc has dates (all last day of the month) in ascending order.
For example below, column F will start with the oldest date, 2/28/17, all the way to most current date, 4/30/18.
Although there is no 7/31/17 and 8/31/17 in columns I, L, and O, I still need that in column F so that no months are skipped in column F.
<tbody>
</tbody>
Columns I, L, O, etc has dates (all last day of the month) in ascending order.
For example below, column F will start with the oldest date, 2/28/17, all the way to most current date, 4/30/18.
Although there is no 7/31/17 and 8/31/17 in columns I, L, and O, I still need that in column F so that no months are skipped in column F.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
2/28/17 | 2/28/17 | 9/30/17 | 1/31/18 | ||||||||||||||||||
3/31/17 | 3/31/17 | 10/31/17 | 2/28/18 | ||||||||||||||||||
4/30/17 | 4/30/17 | 11/30/17 | 3/31/18 | ||||||||||||||||||
5/31/17 | 5/31/17 | 12/31/17 | |||||||||||||||||||
6/30/17 | 6/30/17 | 1/31/18 | |||||||||||||||||||
7/31/17 | 2/28/18 | ||||||||||||||||||||
8/31/17 | 3/31/18 | ||||||||||||||||||||
9/30/17 | 4/30/18 | ||||||||||||||||||||
10/31/17 | |||||||||||||||||||||
11/30/17 | |||||||||||||||||||||
12/31/17 | |||||||||||||||||||||
1/31/18 | |||||||||||||||||||||
2/28/18 | |||||||||||||||||||||
3/31/18 | |||||||||||||||||||||
4/30/18 |
<tbody>
</tbody>