Hi I am a novice at programming and I have a year/month column with dates from 201604 to 202003.  I would like to create a new column where the 1st 3 months will show as 1m, 2nd 3 months will be 2m and so on therefore I would eventually have a new column with data ranging from 1m to 16m. Eventually I would like to have it automated so that I can just alter the date range without having to manually input each indivdual date. Year_Month  _3m_ 201604           1m 201605           1m 201606           1m 201607           2m 201608           2m 201609           2m 201610           3m 201611           3m 201612           3m I have tried to using arrays and macros but rather unsuccessfully  So any help will be greatly appreciated.  G     ... View more