Excel and Adding 6 Months to a Date

[funkylad20]

If I have 'June 2011' in cell C1, what will be the formula to add 6 months to this date to read as 'November 2011'?

[Fibonacci]

might find some help here
http://www.ozgrid.com/Excel/add-month.htm
http://www.computing....add-a-month/6489.html

[bibblebub]

=DATE(YEAR(C1),MONTH(C1)+6,1)
and set the cell format to: mmmm yyy

would be one way to do it (p.s. 6 months after June is December)

[Old_Geezer]

31 November may not be a problem if you are ignoring the day figure anyway.

[funkylad20]

works a treat, thanks people. Sorry, I meant the 6th month, inclusive, so have amended the 6 to a 5.