Hi all,
Can anyone help me with the below question?
I’m sent a file every day where column A contains a month & year but in ‘general’ format.
For example;
Column A, starting with cell A1 with the next date in A2, etc
Jan15
Feb15
Mar15
Apr15
Is there a way through a formula or macro that I can use in order to run through all the dates in this column to make sure that the next cell down is always the month after the cell above it? The dates go all the way through to 2018 in the above format.
Any help would be much appreciated.
Thank you.
Bookmarks