C1:D1=ROUND(SUM((TEXT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(C2,".","/"),"-",REPT(" ",99)),{1,99},99)),"YYY M")&"/12")*{-1,1})*12,)+1
C3:D17=IF(ROW(A1)>C$1,"",IF(ROW(A1)=1,LEFT(C$2,FIND("-",C$2)-1),TEXT(EOMONTH(SUBSTITUTE(LEFT(C$2,FIND("-",C$2)-1),".","/"),ROW(A1)-2)+1,"YYY.M.D"))&"-"&IF(ROW(A1)=C$1,MID(C$2,FIND("-",C$2)+1,19),TEXT(EOMONTH(SUBSTITUTE(LEFT(C$2,FIND("-",C$2)-1),".","/"),ROW(A1)-1),"YYY.M.D")))
留言
張貼留言