Frank Kabel wrote...
try
=DATE(YEAR(A1),MONTH(A1)+1,MIN(DAY(A1),DAY(DATE(YE AR(A1),
MONTH(A1)+2,0))))
..

Why not condense that to

=A1+31-DAY(A1+31)+(MONTH(A1+31)-MONTH(A1)<2)*DAY(A1)


Just a simple reason: I use this kind of formula also adding n months
in the generic form of:
=DATE(YEAR(A1),MONTH(A1)+n,MIN(DAY(A1),DAY(DATE(YE AR(A1),MONTH(A1)+n+1,
0))))

Of course one can adapt your formula also for more than 1 month but as
I'm lazy I just stick to the above solution :-)
But agreed your solution is shorter for adding 1 month