(先) D4 下拉=IFERROR(IF((MOD(LOOKUP(1,0/(D$3:D3<>""),D$3:D3)+(D3="")-2,7)=6)+(DAY(LOOKUP(1,0/(D$3:D3<>""),D$3:D3))=DAY(EOMONTH(A$1,0))),"",LOOKUP(1,0/(D$3:D3<>""),D$3:D3)+1),A$1)
C4 下拉=IF(D4<>"",TEXT(D4,"AAAA"),IF(D3<>"",WEEKNUM(D3,2)&"周周累计",""))
E4 下拉=IF((RIGHT(C4)="计")+(C4=""),"",RANDBETWEEN(1,9))
F4 下拉=IF(RIGHT(C4)="计",SUM(E$3:E3)-SUMIF(C$3:C3,"*计",F$3:F3),"")
另解D4 {=IF((MOD(-LOOKUP(1,-N(+D$3:D3)),7)=1)+MONTH(MAX(D$3:D3)+1)>MONTH(A$1),"",A$1+MAX(DAY(N(+D$3:D3))))
留言
張貼留言