=LET(x_,TEXTAFTER(""&C$2:C2,"2025",,,,""),y_,IF([@DMR]<>"",--(2025&(MAX(IFERROR(--x_,0))+1)),""),y_)
requires Office 365 comp. v. Excel