nutbolt
New member
- Joined
- Nov 9, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
In Excel I have cells in column C that have dates showing every month from the 05.12.13 through to 05.04.15 the fifth day of every month being the deadline date. I wanted to populate another column next to these dates as column D as :
05.12.13 = month 8
05.01.14 = month 9
05.02.14 = month 10
05.03.14 = month 11
05.04.14 = month 12
05.05.14 = month 1
eg...all the way to..
05.10.14 = month 6
05.12.14 = month 8
05.04.15 = month 12
how do I make the new column D populate with these month numbers in a macro??
05.12.13 = month 8
05.01.14 = month 9
05.02.14 = month 10
05.03.14 = month 11
05.04.14 = month 12
05.05.14 = month 1
eg...all the way to..
05.10.14 = month 6
05.12.14 = month 8
05.04.15 = month 12
how do I make the new column D populate with these month numbers in a macro??