欢迎光临朱凯的个人博客!
朱凯,a3.work

excel年龄计算日期差

 发布时间: 2019-03-15 17:48      原创:  朱凯      评论: .       .人查看

0307-1237.jpg

记录分享下: 

// 年月
=IF(MONTH(NOW())>MONTH(B2);YEAR(NOW())-YEAR(B2)&"年"&MONTH(NOW())-MONTH(B2)&"月";YEAR(NOW())-YEAR(B2)-1&"年"&MONTH(NOW())+12-MONTH(B2)&"月")
// 年月日
=IF(MONTH(NOW())>MONTH(B2);YEAR(NOW())-YEAR(B2)&"年"&MONTH(NOW())-MONTH(B2)&"月";YEAR(NOW())-YEAR(B2)-1&"年"&MONTH(NOW())+12-MONTH(B2)&"月")&IF(DAY(NOW())>DAY(B2);DAY(NOW())-DAY(B2)&"天";"差"&DAY(B2)-DAY(NOW())&"天")

XLS示例文件分享

密码: cox2

转载请注明来源:   excel年龄计算日期差  - 朱凯博客

分享是一种快乐,也是一种美德:
¥打开支付宝,扫码领红包¥ 红包

支付宝 aliPay

微信 wxPay