excel填充指定行
年
=(INT((ROW(A1)-1)/372))+1961
月
=MOD((INT((ROW(A1)-1)/31)),12)+1
日
=MOD(ROW(A1)-1,31)+1
组合
=((INT(ROW(A1)/373))+1961)&IF((MOD((INT((ROW(A1)-1)/31)),12)+1)<10,"0","")&MOD((INT((ROW(A1)-1)/31)),12)+1&IF((MOD(ROW(A1)-1,31)+1)<10,"0","")&MOD(ROW(A1)-1,31)+1