Excel表格中怎么计算周岁数
的有关信息介绍如下：
计算到2010-05-01的公式：=DATEDIF(B2,TODAY(),"y")&"岁"&DATEDIF(B2,TODAY(),"ym")&"月"&DATEDIF(B2,TODAY(),"md")&"天"计算到当天的公式：=DATEDIF(B2,"2010-05-01","y")&"岁"&DATEDIF(B2,"2010-05-01","ym")&"月"&DATEDIF(B2,"2010-05-01","md")&"天"
Excel表格中怎么计算周岁数
Simone
发布于 2026-04-18 13:09:00
869 阅读
