AA列为日期格式修正以下代码=COUNTIFA1A11202301
You can use the DATE function to convert the string "2023/01" into a date format. Assuming the dates are in column A, you can modify the code as follows:
=COUNTIF(A1:A11, "" & DATE(2023, 1, 1) & "")
原文地址: https://www.cveoy.top/t/topic/iT5w 著作权归作者所有。请勿转载和采集!