A4:G4=TEXT(COLUMN(A1)-WEEKDAY(DATE($A1,$C1,1),1)+1,"0;;")
A6:G6=IFERROR(IF($G4+COLUMN(A1)>DAY(EOMONTH(DATE($A$1,$C$1,1),0)),"",$G4+COLUMN(A1)),"")
A6:G6複製到A8:G8 A10:G10 ... A14:G14
M30:M32=IF(DAY(EOMONTH(DATE(A$1,C$1,1),0))>=M$29+ROW(A1),M$29+ROW(A1),"")
N2:P32{=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($I:$I,SMALL(IF((DATE($A$1,$C$1,$M2)>=$J$4:$J$10)*(DATE($A$1,$C$1,$M2)<=$K$4:$K$10),ROW($4:$10)),COLUMN(A1)))&O2,"")
A5:G5=IFERROR(VLOOKUP(A4*1,$M:$P,2,),"")
A5:G5複製到A7:G7 A9:G9 ... A15:G15
留言
張貼留言