我想请问 =YEAR(TODAY())-MID(F12,7,4)这个公式的语法姚怎么描述、谢谢
在excel中YEAR(TODAY())-IF(LEN(C2)=15,"19"&MID(C2,7,2),MID(C2,7
公式=IF(L8"",YEAR(L8)-YEAR(K8),(YEAR(TODAY())-YEAR(K8)))的复制单元格
用mid函数提取数字我想用mid函数提出日期中2011-07-14 14:41:44(在A1)的天,公式为=mid(A1
=IF(LEN(A1)=18,(YEAR(NOW())-MID(A1,7,4))&"岁"&MID(A1,11,2)&"月
一个美国客户要这个号码清关,什么样的企业才会有这个MID啊?请问MID在哪里查呢、谢谢各位了急~
EXCEL的题目=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100)
=IF(MID(F9,17,1)/2=TRUNC(MID(F9,17,1)/2),"女","男")这个公式怎么理解啊
函数公式=MID(B3,7,4)&MID(B3,1,2)&MID(B3,4,2)&"A"和=IF(A3="A",D2,I
公式“=(YEAR(TODAY())-YEAR(B8))*12+(MONTH(TODAY())-MONTH(B8))-1
请问这个公式怎么写?先谢谢您昨天的热心解答!
求大神解释"=DATEVALUE(MID(D4,7,4)&"-"&MID(D4,11,2)&"-"&MID(D4,13,
Mid-Autumn Day (中秋节)这个单词的音标怎么写?