拜託高手幫忙，我要用EXCEL算實際出生年齡 如：http://isvincent.blogspot.com/2011/05/excel-datedif.html?
回答 (2)
2017-06-12 2:03 pm
如出生日期在D4
=DATEDIF(D4,TODAY(),"y")&"歲"&IF(DATEDIF(D4,TODAY(),"ym")=0,"",DATEDIF(D4,TODAY(),"ym")&"個月")&IF(DATEDIF(D4,TODAY(),"md")=0,"","又"&DATEDIF(D4,TODAY(),"md")&"天")
=DATEDIF(D4,TODAY(),"y")&"歲"&IF(DATEDIF(D4,TODAY(),"ym")=0,"",DATEDIF(D4,TODAY(),"ym")&"個月")&IF(DATEDIF(D4,TODAY(),"md")=0,"","又"&DATEDIF(D4,TODAY(),"md")&"天")
2017-06-11 11:32 am
收錄日期: 2021-04-28 17:34:51
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170610201546AAbRE8U