Add X number of months to a date


Add X number of months to a date in Excel

=MIN(DATE(YEAR(A2);MONTH(A2)+B2+{0;1};DAY(A2)*{1;0}))