I am using this formula to calculate the new and returning customers per month.

=COUNTIFS(neww,1,date,">="&BH2,date,"<="&EOMONTH(BH2,0))

Im getting 0 everywhere. What I am doing wrong here?

This is the excel file :

CodePudding user response：

It seems your month column is actually string values. So, try wildcards in Countif() criteria. Try-

=COUNTIFS($F$2:$F$99,"*"&BH2,$G$2:$G$99,1)