:::

6-2-3 西元年換為民國年 (excel 公式)

1988/1/6  換為770106

=TEXT(YEAR(A1)-1911,"00")&TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")