End of Month (EMONTH)

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

B1 = Months to add

© Copyright 2004 - 2007, andrewsexceltips.com. All Rights Reserved.