D3:J8=TEXT(TEXT(ROW(A1)*7-7+COLUMN(A1)-MOD(WEEKDAY(($B$2&-$B$6),2),7),"[<="&DAY(EOMONTH(($B$2&-$B$6&-1)*1,0))&"];0;"),"0;;")
L3:R8=TEXT(TEXT(ROW(A1)*7-7+COLUMN(A1)-MOD(WEEKDAY(($B$2&-$B$6),2)-1,7),"[<="&DAY(EOMONTH(($B$2&-$B$6&-1)*1,0))&"];0;"),"0;;")
D13:J18=TEXT(TEXT(ROW(A1)*7-7+COLUMN(A1)-MOD(WEEKDAY(($B$2&-$B$6),2)+1,7),"[<="&DAY(EOMONTH(($B$2&-$B$6&-1)*1,0))&"];0;"),"0;;")
三種公式 紅字差別
留言
張貼留言