如何用excel計算年齡試試可否。=DATEDIF(A1,"2010/11/15","Y")"周歲"{0}2,在excel里怎樣計算年齡用DATEDIF函數在A1輸入出生日期,=DATEDIF(A1,TODAY(),"Y"){1}3,在excel中怎么計算年齡下面的公式計算周歲年齡:=DATEDIF(TEXT(A1,"#-00-00"),TODAY(),"y")19830427是日期格式...