Counting Completed Jobs this Month and Last Month

[Babylon5]

Good Evening

I have a column of data on my Finished sheet where the date the job was completed is recorded in column R, recorded in date format such as 04-Feb.

I want to count how many were finished this month, I was thinking the formaula would be like this :

=COUNTIF(Finished!R:R,MONTH(TODAY()))

and for last month =COUNTIF(Finished!R:R,MONTH(TODAY())-1)

But it shows 0, Can you help ?

Many thanks

Rich

 

[LazyBug]

Hello!
Maybe (replace the selected data range with yours)

=SUMPRODUCT(--(MONTH($R$1:$R$20)=MONTH(TODAY())))

and

=SUMPRODUCT(--(MONTH($R$1:$R$20)=MONTH(TODAY())-1))

?

 

[Fluff]

Another option

=COUNTIFS(Finished!R:R,">="&EOMONTH(TODAY(),-1)+1,Finished!R:R,"<"&EOMONTH(TODAY(),0)+1)