B1=YEAR(TODAY())
H1=MONTH(TODAY())
AG4:AI4=IF(COLUMN(A1)+28>DAY(EOMONTH($B1&-$H1,0)),"",AF4+1)
E5:AI5=IF(E4="","",MID(IF(ROW(A1)>2,"△维△△值△","△值△△维△"),MOD(DATE($B$1,$H$1,E$4)+ROW(A1)-1,6)+1,1))
E6:AI6=IF(E4="","",IF(E5="维","值",IF(E5="值","维","△")))
E5:AI6複製到E7:AI10
格式化 E4:AI4=MOD(DATE($B1,$H1,E4)-2,7)>4
留言
張貼留言