C3:H14=IF(COLUMN(A1)>ROUNDUP((WEEKDAY(DATE($A$3,$B3,1),2)-1+DAY(EOMONTH(DATE($A$3,$B3,1),0)))/7,),"",$A$3&"."&$B3&"."&IF($A$2=A$2,1,MAX(IFERROR(RIGHT(B3,{1,2})+1,1)))&"-"&$B3&"."&MIN((8-WEEKDAY(DATE($A$3,$B3,1),2))+(COLUMN(A1)-1)*7,DAY(EOMONTH(DATE($A$3,$B3,1),0))))
B 有月份字樣 C3:H14{=IF(COLUMN(A1)>ROUNDUP((WEEKDAY(DATE($A$3,LEFTB($B3,2),1),2)-1+DAY(EOMONTH(DATE($A$3,LEFTB($B3,2),1),0)))/7,),"",$A$3&"."&LEFTB($B3,2)*1&"."&MAX(IFERROR(RIGHT(B3,{1,2})+1,1))&"-"&LEFTB($B3,2)*1&"."&MIN((8-WEEKDAY(DATE($A$3,LEFTB($B3,2),1),2))+(COLUMN(A1)-1)*7,DAY(EOMONTH(DATE($A$3,LEFTB($B3,2),1),0))))
留言
張貼留言