Countif for entire current month and previous month

[willow1985]

I am looking for a formula that counts all the dates in a list of the current month and of the previous month. I have this formula but I am getting no results when I should be receiving: 210 results

=COUNTIF(G2:G1000000,MONTH(TODAY()))

Any help would be appreciated

Thank you

Carla

 

[Joe4]

Try:

[COLOR=#0000ff]=SUMPRODUCT(--(TEXT(G2:G1000000,"mmyyyy")=TEXT(TODAY(),"mmyyyy")))[/COLOR]+[COLOR=#ff0000]SUMPRODUCT(--(TEXT(G2:G1000000,"mmyyyy")=TEXT(EDATE(TODAY(),-1),"mmyyyy")))[/COLOR]

Note that the blue part does this month, and the red part does last month.

 

[Fluff]

Another option
=SUMPRODUCT((G2:G1000000>=EOMONTH(TODAY(),-2)+1)*(G2:G1000000<=EOMONTH(TODAY(),0)))

 

[willow1985]

Sorry I did not specify. I needed 2 individual formulas. One that counts current month and one that counts previous month.

But the above formula did not count all the dates that were in Sept and Aug. I still not a 0 result.

I have this formula that is working but it is only meant to count yesterday: =COUNTIF(G2:G1000000,TODAY()-1)

The result was 18 dates.

If it counted every date in the month of Sept I would have got over 200 results.

Thank you very much

Carla

 

[Fluff]

In that case just split Joe's formula into two.

 

[willow1985]

I understand what I was entering in incorrectly.

The formula works perfect. Thank you very much

Is there a way to Sum it instead of count as well? If G2:G10000 was a dollar value instead of a date?

 

[willow1985]

Actually this question is more complicated. I will start a new thread.

Thank you again!!