excel表格中给出一个日期,如2011-11-1,怎么判断这个月分有多少个周六...答:=COUNT(1/(WEEKDAY(EOMONTH(A1,-1)+ROW(INDIRECT("1:"&DAY(EOMONTH(A1,0))),2)>5))crtl+shift+enter结束公式 如果没加载eomonth函数 =COUNT(1/(WEEKDAY(DATE(YEAR(A1),MONTH(A1),0)+ROW(INDIRECT("1:"&DAY(DATE(YEAR(A1),MONTH(A1)+1,0))),2)>5))crtl+shift+enter结束公式 ...