End of Month (EMONTH)

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

B1 = Months to add



© Copyright andrewsexceltips.net All Rights Reserved.