年紀 算出年月日 有民國與西元年 (13872)

B3=TEXT(SUM(DATEDIF(-LOOKUP(1,-IF({1,0},"R"&A3,A3)*1),TODAY(),{"Y","YM","MD"})*10^{4,2,0}),"000年00月00日")

A14=TEXT(TODAY()-1,"Y/MM/DD")

A15=TEXT(TODAY()-1,"E/MM/DD")