Adding a month to a referenced cell

[solo9999]

Hi all,

Deceiving title I know, but here's the breakdown:

I have a list with dates in A2, format is 7/1/2011

I also have a formula in A3 which references to A2:

=UPPER(TEXT(A2,"mmm")&" - DEC")

The A3 output is 'JUL-DEC'

Is there a way to amend the A3 formula so it will add a month to whatever is in A2? In other words, if A2 is 7/1/2011 then A3 would display 'AUG-DEC'?

!Thanks!

 

[cb12]

Probably a better way of doing it but try:

=UPPER(TEXT((MONTH(A2)+1)* 30,"mmm")&" - DEC")

 

[solo9999]

Thank you cb12, that worked just fine!