统计大于某个日期的个数.xlsxVIP

入网日期 要统计每一周从周一到到今天的个数 统计大于等个数（这一列的数据格式不能修改）20200402 =COUNTIF(A:A,=TEXT(IF(WEEKDAY(TODAY(),2)=1,TODAY(),TODAY()-WEEKDAY(TODAY(),2)+1),emmdd)) 使用这个函数一直提示这个202004042020040320200405202004092020041120200409202004092020041220200409202004122020041620200414202004142020041620200415202004172020041620200415202004162020041620200419

20200420