=DATEDIF(TEXT(A1,"0-00"),TODAY(),"y")
-
-
-
=datedif(text(a1,"00-00"&"-15"),today(),"y")
-
=DATEDIF(C2,TODAY(),"y")
C2為出生日期（日期格式） -
參照圖片操作