假设A4是出生日期
Excel计算周岁公式：
DATEDIF(A4,TODAY(),"Y")
Excel计算虚岁公式：
YEAR(TODAY())-YEAR(A4)
具体如图：
如果需要批量应用，鼠标选中B4或者C4（共识生成的第一个数据），然后鼠标移动到选框右下角，待出现实线+号时，向下拖动即可。
相关推荐：WPS表格提取身份证号中的出生年月日并且自动计算年龄的方法
(adsbygoogle = window.adsbygoogle || []).push({});
来源：https://www.02405.com/archives/1815
微信公众号
手机浏览(小程序)
Warning: get_headers(): SSL operation failed with code 1. OpenSSL Error messages:
error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
Warning: get_headers(): Failed to enable crypto in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
Warning: get_headers(https://static.shanhubei.com/qrcode/qrcode_viewid_6870.jpg): failed to open stream: operation failed in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
