Help with date formula

[Stuartj1]

Hi

I need a formula which will return the first day in the next month based upon a known date . So if I had 26/8/11 in A1 what would the formula be which would return 1/9/11 in B1 (still in date format).

Obviously it needs to cope with the year change for a December date in A1.

Thanks in advance.

 

[gaj104]

Try

=DATE(YEAR(A1),MONTH(A1)+1,1)

 

[Stuartj1]

Thank you Graeme

 

[jasonb75]

Or

=EOMONTH(A1,0)+1