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!