=(N(DATEDIF(A4,TODAY(),"Y")))*50在工作中是什么意思?
=DATEDIF("2005-12-21",TODAY(),"Y")
=DATEDIF(B2,TODAY(),"Y") 括号里该输什么,
excel中没有datedif这个公式,在单元格输入公式=datedif(A1,TODAY(),"Y")结果返回错误值#
EXCEL函数解释:{=SUM((DATEDIF(D2:D21,TODAY(),"Y")>=5)*1)}
IF(AND(MONTH(A1)>=9,DAY(A1)>=1),DATEDIF(A1,TODAY(),"y")-1,DA
=DATEDIF(TEXT(MID(F5,7,LEN(F5)/2-1),"0-00-00"),TODAY(),"Y")
请解释以下函数 =TEXT(SUM(DATEDIF(G2,TODAY(),{"Y","YM"})*10^{2,0}),"
=DATEDIF 2012-5-12 2012-5-13 用函数DATEDIF(H2,TODAY(),"D") 算出来是
=DATEDIF(TEXT(A1,"0-00-00"),TODAY(),"y")这个函数怎么解读,"0-00-00"是怎
=DATEDIF(TEXT(SUBSTITUTE(2007.10,".","-"),"yyyy-mm"),TODAY()
以当前时间计算年龄的代码:=datedif(A1,today(),"y")中A1在1900年后出生的人寿计算准确,此前出
TEXT(SUM(DATEDIF(A1,TODAY(),{"Y","YM","MD"})*10^{4,2,0}),"0年