A3{=IFERROR(TEXT(SMALL(IF(MOD((1&-1)+ROW($1:$365)+(DAY(EOMONTH("2/1",0))=29)-3,7)=6,MONTH((1&-1)+ROW($1:$365)+(DAY(EOMONTH("2/1",0))=29)-1)),ROW(A1))&"/1","MMM"),"")
另解A3{=IFERROR(TEXT((SMALL(IF(MMULT(COLUMN(A:NB)^0,N(IF(MOD((1&-1)+ROW($1:$366)-3,7)=6,TEXT((1&-1)+ROW($1:$366)-1,"EMM")*1)=TEXT(NOW(),"E")/1%+COLUMN(A:L)))>=ROW($1:$12),COLUMN(A:L)),ROW(A1))&-1)*1,"MMM"),"")
B3=COUNTIF(A$3:A3,A3)
D3:E3 下拉=1-WEEKDAY(1&$A3,2)+(1&$A3)+MOD(ROW(A1)-1,4)*7+(A3=$B3)*6
留言
張貼留言