D2{=TEXT(SMALL(IF(WEEKDAY(DATE(CODE(MID(B2,2,1))+1933,CODE(MID(B2,3,1))-64,ROW($1:$31)),2)=C2,DATE(CODE(MID(B2,2,1))+1933,CODE(MID(B2,3,1))-64,ROW($1:$31))),MID(B2,4,1)),"YYYMMDD")
F2=CODE(MID(B2,2,1))+1933
G2=TEXT(CODE(MID(B2,3,1))-64,"00")
H2=1-WEEKDAY(DATE(F2,G2,1),2)+(MID(B2,4,1)-(WEEKDAY(DATE(F2,G2,1),2)<=C2))*7+C2
留言
張貼留言