B2:O2{=IFERROR(SMALL(IF(MMULT(N(IFERROR(MOD(($A$4&"/"&ROW($1:$31))-2,7),9)=IF($A$3=$A3,{0,2,5},{1,3,6})),{1;1;1})*(IFERROR(MONTH($A$4&"/"&ROW($1:$31)),)=$A$4),ROW($1:$31)),COLUMN(A1)),"")
B3:O3=IF(B2="","",RIGHT(TEXT($A$4&"/"&B2,"AAA")))
B2:O3 複製到B5:O6
留言
張貼留言