第1个回答 2010-09-08
=YEAR(NOW())-YEAR(h1)
i列要设置格式为数字 0位小数
精确
=YEAR(DATE(YEAR(NOW()),MONTH(NOW())-MONTH(A1)+1,DAY(NOW())-DAY(A1)+1))-YEAR(A1)本回答被提问者采纳
第2个回答 2010-09-08
=DATEDIF(H2,TODAY(),"y")&"年"&DATEDIF(H2,TODAY(),"ym")&"月零"&DATEDIF(H2,TODAY(),"md")&"日"
结果为:4年3月零2日
第3个回答 2010-09-08
I2输入:=DATEDIF(H2,NOW(),"y")
然后往下拉