在Excel中有两列 出生年月 年龄 1967.10 1967.05 请问用函数如何计算年龄?出生年月不是日期型的。

=DATEDIF(SUBSTITUTE(A1,".","-")&"-1",TODAY(),"Y")

---------------------------------------------------------------
=YEAR(NOW())-LEFT(A2,4)

Published At
Categories with 服务器类
Tagged with
comments powered by Disqus