每月最早與最后的指定星期 (10028)

 

C2:D8{=INDEX(PERCENTILE(IF((WEEKDAY(EOMONTH($A2,-1)+ROW($1:$31),2)=$B2)*(ROW($1:$31)<=EOMONTH($A2,0)),EOMONTH($A2,-1)+ROW($1:$31)),{0,1}),COLUMN(A1))