Add 1 month to a date to give the EOM of following month

[STUARTXL]

Hi All,

Recently I've undertaken a lot of Excel learning and my brain is swamped, so forgive me if the answer to the following is obvious...

In one cell I have the date 31/08/2016. In another cell I'm trying to generate the 'End of Month' date of the following month, that being 30/09/2016.

My current formula:
=DATE(YEAR($C$8),MONTH($C$8)+1,DAY($C$8))
is generating a result of 01/10/2016 when the result I want is 30/09/2016. No doubt this is something to do with the formula adding 31 days oppose 30, but how do I overcome this?

The date of 31/08/2016 is of course in cell C8

[etaf]

=EOMONTH(C8,1)

the 2nd element defines how many months to go ahead
0 - this month
1 - the next month - 1 month ahead
2 - 2 months ahead

[AlanY]

try this

=EOMONTH($C$8,1)

[STUARTXL]

So obvious. Thanks guys. Think I need a rest.