假设C4单元格中的内容为出身年月，则计算准确的年龄的公式如下：
=IF( DATEDIF(C4,TODAY(),"y")=0 ,"" ,TEXT(DATEDIF(C4,TODAY(),"y"),"0")&"岁") & IF(DATEDIF(C4,TODAY(),"ym")=0,"",TEXT(DATEDIF(C4,TODAY(),"ym"),"0")&"个月") & IF(DATEDIF(C4,TODAY(),"md")=0,"整","零"&TEXT(DATEDIF(C4,TODAY(),"md"),"0")&"天") & "（共计" & TEXT(DATEDIF(C4,TODAY(),"d"),"0")&"天）"
文章内容由WPS之家(wps.qiangguoshuo.com)收集于网络，希望能为广大朋友提供帮助。
根据出生年月在Excel中计算准确年龄的方法图解教程
转载声明：本站发布文章及版权归原作者所有，转载本站文章请注明文章来源！
