Excel COUNTIF Formula to Count Dates in 2023/01
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/qz4H 著作权归作者所有。请勿转载和采集!