How to assign a cell to a countif function

[Tyrel Smith]

Can someone help me please,

I'm trying to get this COUNTIF function's criteria to be a cell (see image below)

it works fine when I have it as =COUNTIF(P2100:P2205;"Nov 2020")
but then every month I would have to change it manually.
cell N2208(highlighted in green) updates automatically every month that's why I want to use N2208 as the criteria for it but when I use it as =COUNTIF(P2100:P2205;N2208) it doesn't work.
I'm using excel 2010
Any help will be muchly appreciated even if it is a vba script.

thank you

 

[Fluff]

What is in N2208?

Please update your account details to show which version of Excel you are using. It saves you from having to tell us every time.

 

[Tyrel Smith]

What is in N2208?

Please update your account details to show which version of Excel you are using. It saves you from having to tell us every time.

Today() function and the formated the cell to display Nov 2020.

the cell is next to the cell with 11 in it(to the left of it)

 

[Fluff]

Ok, that's probably the reason as the formula is looking for cells with today's date.
Try

=TEXT(TODAY(),"mmm yyyy")

instead.

 

[Tyrel Smith]

Ok, that's probably the reason as the formula is looking for cells with today's date.
Try

=TEXT(TODAY(),"mmm yyyy")

instead.

I tried that and I get the current month and year (displayed in cell highlighted in red) but the cell highlighted in blue is still 0 yet the cells above it have Nov 2020

 

[Fluff]

What do you have in col P?

 

[Tyrel Smith]

What do you have in col P?

Dates ie. 12/10/2017 that have been formatted to show month and year

 

[Fluff]

In that case how about

=COUNTIFS(P:P,">="&EOMONTH(N2208,-1)+1,P:P,"<="&EOMONTH(N2208,0))

with N2208 having your original formula

 

[Tyrel Smith]

In that case how about

=COUNTIFS(P:P,">="&EOMONTH(N2208,-1)+1,P:P,"<="&EOMONTH(N2208,0))

with N2208 having your original formula

so I must put COUNTIF(P2195:P2206 into N2208, what must I put the criteria as?
and =COUNTIFS(P:P,">="&EOMONTH(N2208,-1)+1,P:P,"<="&EOMONTH(N2208,0)) in P2207

 

[Fluff]

No N2208 needs to be formula you originally had in that cell, ie the Today function.