DATE EXPIRATION Formula

I have a cell that reads like this 2013 08 28. In another cell I need it to read 2023 08 27 (10 years ahead, 1 day behind). I have used a date formula =DATE(YEAR(A1)+10,MONTH(A1),DAY(A1)-1). However since the YYYY MM DD is custom, the formula does not understand the date format. Is there a formula that will fix this issue?

Thanks!

A1 is not a formula.

Check the formula I added to my post (I added it probably after you posted your response.)

Thanks! that formula helped.

You're welcome.