=(LEFT(A1,4)+1)&(MID(A1,5,LEN(A1)-4))
如果A1是日期的第一个,在B1中输入上面的公式试试
--------------------------------
=(YEAR(SUBSTITUTE(A1,".","-")-1)+1)&"."&MONTH(SUBSTITUTE(A1,".","-")-1)&"."&DAY(SUBSTITUTE((LEFT(A1,4)+1)&MID(A1,5,LEN(A1)-4),".","-")-1)
-------------------------------------------
你应该追加分给我,因为我等的好辛苦啊!!!!