I have data:
4/22/16
4/22/16
4/22/16
4/22/16
11/13/20
11/13/20
5/14/16
5/14/16
5/14/16
5/14/16
5/14/16
5/14/16
5/14/16
This is just a sample of hundreds lines of data. How would I create a macro that lets me add a day to the previous day before it (but stops when the following day isn't the same ? and then contines to the next line) So, I would want
4/22/16
4/23/16
4/24/16
4/25/16
11/13/20
11/14/20
5/14/16
5/15/16 and etc...
Bookmarks