B6:H11=TEXT(TEXT(-MOD(($B$2&-$B$3)-2,7)+COLUMN(A1)+ROW(A1)*7-7,"[<="&DAY(EOMONTH($B$2&-$B$3,0))&"]0;"),"[>]0;")
B6:H11另解=IF(MONTH(DATE($B$2,$B$3,-MOD(($B$2&-$B$3)-2,7)+COLUMN(A1)+ROW(A1)*7-7))<>$B$3,"",-MOD(($B$2&-$B$3)-2,7)+COLUMN(A1)+ROW(A1)*7-7)
B15:H15=TEXT(-MOD(($B$2&-$B$3)-2,7)+COLUMN(A1),"0;;")
B16:H20=TEXT($H$15+COLUMN(A1)+ROW(A1)*7-7,"[<="&DAY(EOMONTH($B$2&-$B$3,0))&"]0;")
K6:Q11=-MOD(($B$2&-$B$3)-2,7)+COLUMN(A1)+ROW(A1)*7-7
K6:Q11格式化=MONTH(DATE($B$2,$B$3,K6))<>$B$3
It does not work. What is the function of the Column (A1) and ROW(A1) part?
回覆刪除Moving the ROW and COLUMN buttons to the right and then dropping them down will change the numbers.
刪除