COUNTIF not working

I am trying to figure out why this formula is not working: =COUNTIF(D:D, "*Nov*") It returns "0" I have included a screenshot of part of column D. As you can see, there are plenty of cells wit...

excel

Formulas and Functions

SergeiBaklan
Dec 02, 2025
Dates in Excel are actually integer numbers starting from 1 which 01 Jan 1900. Applying format like "dd-mmm-yyyy" doesn't change cell values. For example cell formatted as 25-Nov-2025 still has as value integerr number 45986. Applying of any format doesn't change the value, only the way how we see it in the cell.
Thus COUNTIF() counts nothing on text "Nov". Altenatively you may use
=SUMPRODUCT(--(MONTH(D:D)=11))

SergeiBaklan

Diamond Contributor

Dec 02, 2025

Dates in Excel are actually integer numbers starting from 1 which 01 Jan 1900. Applying format like "dd-mmm-yyyy" doesn't change cell values. For example cell formatted as 25-Nov-2025 still has as value integerr number 45986. Applying of any format doesn't change the value, only the way how we see it in the cell.

Thus COUNTIF() counts nothing on text "Nov". Altenatively you may use

=SUMPRODUCT(--(MONTH(D:D)=11))

FbxSteve
Copper Contributor
Dec 02, 2025
Thank you!

Forum Discussion

COUNTIF not working

Resources