excel计算两个日期之间有几年几个月答:=DATEDIF(SUBSTITUTE(B2,".","-"),SUBSTITUTE(C2,".","-"),"Y")&"年"&DATEDIF(SUBSTITUTE(B2,".","-"),SUBSTITUTE(C2,".","-"),"YM")&"个月"
excel里如何将内容自动填充下面空白行并要有区分,如图,求公式,高分...答:在B列只用公式构造图二的数列,然后在把B列生成的数据选择性粘贴数值回到A列即可达成你需要的结果。公式:=LOOKUP(ROW(A1),IF($A:$A<>"",ROW($1:$100)),A:A)&IF(A1<>"","",(ROW()-MATCH(LOOKUP(ROW(A1),IF($A:$A<>"",ROW($1:$100)),A:A),A:A,0)+1))数组公式,使用...