假设A4是20130101
=TEXT(DATE(LEFT(A4,4),MID(A4,5,2)+6,RIGHT(A4,2)-1),"yyyymmdd")
可用公式：=TEXT(EDATE(TEXT(A1,"0-00-00"),6)-1,"emmdd")
