=SUBSTITUTE(TEXT(A1,"00-00"),"-",":
=SUBSTITUTE(TEXT(A1,"00-00"),"-",":
=SUBSTITUTE(TEXT(A9/10000,"0.00.00"),".",":")*24
=TEXT(HOUR(A1),"00")&":"&TEXT(MINUTE(A1),"00")求解析整个公式各个部分的含义
=DATEDIF(TEXT(SUBSTITUTE(2007.10,".","-"),"yyyy-mm"),TODAY()
=DATEDIF(TEXT(MID(A1,7,INT(LEN(A1)/2-1)),"#-00-00"),"2010-12
比如:=TEXT((LEN(A1)=15)*19&MID(A1,7,6+(LEN(A1)=18)*2),"#-00-00
=DATEDIF(TEXT(A1,"0-00-00"),TODAY(),"y")这个函数怎么解读,"0-00-00"是怎
TEXT(SUM(DATEDIF(A1,NOW(),{"y","ym","md"})*10^{4,2,0}),"0年00
=TEXT(ROW(A1)*2-1,H-164-")&TEXT((ROW(A2)-1)*2,"100") 这个公式中,如
excel中的公式"=TEXT(DATE(LEFT(A1,4),MID(A1,6,2),RIGHT(A1,3)),"yy
exel 2010英文版公式=TEXT(WEEKDAY(A1),"dddd")无法返回英文值
谁来解读一下这个EXCEL公式的具体意思呀?=SUBSTITUTE(SUM(IF(A2:E2=F1,A1:E1)*10^