Increasing MM.YYYY Label by 1 month

[dbernart]

Is there a way to have a formula add one month to a pseudo-date label ('MM.YYYY)?

Excel Workbook
	AT	AU	AV
2	11.2012	12.2012	01.2013
WorldWide-New

Given the text label in AT2, can you put a formula in AU2 onward that would add one to the previous "month" and keep it as a label? Also can you have it increase the year by one if the month is December?

Yes, I know that if it was an actual date, it would be much easier using the Date function... but I'm limited to the text label in AT2.

Thanks,
Doug

 

[Jonmo1]

Try

=TEXT(EDATE(SUBSTITUTE(AT2,".","/")+0,1),"m.yyyy")


This requires the Analysis Toolpack Addin from Tools - Addins.

 

[dbernart]

Nice job! The only thing I had to do was change your "m" to "mm" and it worked like a charm!

Many thanks!!

Doug