C2=TEXT(ROUNDUP((TEXT(A2&"日","d")+MOD(EOMONTH(A2&"日",-1)-1,7))/7,),"第[DBNUM1]0周")
另解=TEXT(SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT((LEFT(A2,FIND("月",A2))&"1日")*1&":"&(A2&"日")*1)),2)=1))+(WEEKDAY(LEFT(A2,FIND("月",A2))&"1日",2)>1),"第[DBNUM1]0周")
另解=TEXT(ROUNDUP((TEXT(A2&"日","d")+MOD(WEEKDAY(EOMONTH(A2&"日",-1),2),7))/7,),"第[DBNUM1]0周")
留言
張貼留言