开始日第幾周的星期 (9603)

C2{=SMALL(IF(MOD(G$2+ROW($1:$365)-3,7)+1=FIND(RIGHT(A2),"一二三四五六日"),ROW($1:$365)-1),B2)+G$2

另解{=SMALL(IF(MOD(G$2+ROW($1:$365)-3,7)+1=LOOKUP(1,0/(TEXT(ROW($2:$8),"AAAA")=A2),ROW($1:$7)),ROW($1:$365)-1),B2)+G$2

另解{=FLOOR(G$2,7)+B2*7-6+MATCH(A2,TEXT(ROW($2:$6),"aaaa"),)

另解=G$2+7*(B2-1)+FIND(RIGHT(A2),"一二三四五")