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

--
Don Guillett
SalesAid Software

"Gofer" wrote in message
...
I am trying to put in a formula that will go to a target date, add 12
months
but be the last day of the month. I tried going plus 13 months minus the
pointed to day of the month minus one more day. Any help would be
appreciated.

Thanks,