Or, with two fewer operations <g:

=DATE(YEAR(A1),MONTH(A1)+13,0)

The zeroth day of the month, to XL, is the last day of the previous
month.


In article ,
"Don Guillett" wrote:

=DATE(YEAR(H1)+1,MONTH(H1)+1,1-1)