请解释以下函数 =TEXT(SUM(DATEDIF(G2,TODAY(),{"Y","YM"})*10^{2,0}),"
请解释以下函数 =TEXT(SUM(DATEDIF(G2,TODAY(),{"Y","YM"})*10^{2,0}),"
TEXT(SUM(DATEDIF(A1,TODAY(),{"Y","YM","MD"})*10^{4,2,0}),"0年
TEXT(SUM(DATEDIF(A1,NOW(),{"y","ym","md"})*10^{4,2,0}),"0年00
EXCEL函数解释:{=SUM((DATEDIF(D2:D21,TODAY(),"Y")>=5)*1)}
=DATEDIF(TEXT(MID(F5,7,LEN(F5)/2-1),"0-00-00"),TODAY(),"Y")
=DATEDIF(TEXT(A1,"0-00-00"),TODAY(),"y")这个函数怎么解读,"0-00-00"是怎
=DATEDIF(TEXT(SUBSTITUTE(2007.10,".","-"),"yyyy-mm"),TODAY()
=DATEDIF("2005-12-21",TODAY(),"Y")
excel中身份号计算年龄 today 怎么改 =DATEDIF(TEXT(19*MOD(LEN(A1),2)&MID(
DATEDIF(TEXT(MID(O5,7,8),"0000-00-00"),TODAY(),"y")
=DATEDIF 2012-5-12 2012-5-13 用函数DATEDIF(H2,TODAY(),"D") 算出来是
=DATEDIF(B2,TODAY(),"Y") 括号里该输什么,