æ¥æ¥è¡¨A4=TEXT(SUM(IF(--SUBSTITUTE(å·¥ä½è¾å
¥!$A:$A,".","-")=TODAY(),å·¥ä½è¾å
¥!C:C)),"0;;")
å¨æ¥è¡¨A4=TEXT(SUM(IF(WEEKNUM(--SUBSTITUTE(å·¥ä½è¾å
¥!$A:$A,".","-"))=WEEKNUM(TODAY()),å·¥ä½è¾å
¥!C:C)),"0;;")
ææ¥è¡¨A4=TEXT(SUM(IF(MONTH(--SUBSTITUTE(å·¥ä½è¾å
¥!$A:$A,".","-"))=MONTH(TODAY()),å·¥ä½è¾å
¥!C:C)),"0;;")
å¹´æ¥è¡¨A4=TEXT(SUM(IF(YEAR(--SUBSTITUTE(å·¥ä½è¾å
¥!$A:$A,".","-"))=YEAR(TODAY()),å·¥ä½è¾å
¥!C:C)),"0;;")
å
¬å¼å
¨é¨æ¨ªæã
温馨提示:答案为网友推荐,仅供参考