要用上一个辅助列来完成A1输入"2012年12月" B1单元格输入公式=SMALL(IF(TEXT(ROW(INDIRECT(A$1&":"&DATE(YEAR(A$1),MONTH(A$1)+1,))),"aaa")={"六","日"},TEXT(ROW(INDIRECT(A$1&":"&DATE(YEAR(A$1),MONTH(A$1)+1,))),"D")*1),ROW(A1))&"日"数组公式,按下SHIFT+CTRL+ENTER三键结束输入,再下拉复制公式至B10单元格 C1单元格输入公式=SUBSTITUTE(TRIM("双休日("&B1&" "&B2&" "&B3&" "&B4&" "&B5&" "&B6&" "&IF(ISERR(B7),"",B7)&" "&IF(ISERR(B8),"",B8)&" "&IF(ISERR(B9),"",B9)&" "&IF(ISERR(B10),"",B10))&")"," ",",")这样的要求,想让公式在一个单元格里完成,很难.如果用VBA应该可以做到,这个我就帮不上忙了
