求实际年龄

ihxkj228 · 发表于 2019-8-13 16:15

求C2，日期相减得到实际年龄,足1岁显示岁，不足1岁显示月份。

龍膽草 · 发表于 2019-8-13 16:23

=IF((YEAR(A2)-YEAR(B2))>1,TEXT(A2-B2,"y岁m月"),TEXT(A2-B2,"m月"))

liu2336904 · 发表于 2019-8-13 16:28

蒙个？
=TEXT(DATEDIF(B2,A2,"y"),"0岁;;"&TEXT(A2-B2,"m月"))

eqzh · 发表于 2019-8-13 16:35

=TEXT(INT(DATEDIF(B2,A2,"M")/12),"00")&"岁"&(MOD(DATEDIF(B2,A2,"M"),12)+1)&"月"

我走我流 · 发表于 2019-8-13 16:44

=IF(DATEDIF(B2,A2,"m")<1,"1月",TEXT(DATEDIF(B2,A2,"y"),"00岁;;;")&TEXT(DATEDIF(B2,A2,"ym"),"0月;;;"))
仅供参考

solextrade · 发表于 2019-8-13 16:49

复制代码

丢丢表格 · 发表于 2019-8-13 16:49

本帖最后由丢丢表格于 2019-8-13 17:15 编辑

liu2336904 发表于 2019-8-13 16:28
蒙个？
=TEXT(DATEDIF(B2,A2,"y"),"0岁;;"&TEXT(A2-B2,"m月"))

=TEXT(DATEDIF(B2,A2,"y"),"0岁;;"&DATEDIF(B2,A2,"ym")&"个月")

月份中的 "ym" ,可以省去 "Y" .
=TEXT(DATEDIF(B2,A2,"y"),"0岁;;"&DATEDIF(B2,A2,"m")&"个月")

象山海鲜 · 发表于 2019-8-13 16:51

复制代码

ihxkj228 · 发表于 2019-8-13 16:53

感谢各位大神

liu2336904 · 发表于 2019-8-13 17:00

丢丢表格发表于 2019-8-13 16:49
=TEXT(DATEDIF(B2,A2,"y"),"0岁;;"&DATEDIF(B2,A2+1,"ym")&"个月")

哈哈，还是丢丢老师细心，我看着日期之间的关系都头大

		自动登录	找回密码
密码			免费注册

[已解决] 求实际年龄