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

 

[Tyrel Smith]

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

Thank you so so much I can finally get rid of the headache

 

[Tyrel Smith]

Thank you so much.

Could you possibly answer my other question

how-to-find-blank-cells-in-a-range-and-the-get-reference-to-them

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Tyrel Smith]

You're welcome & thanks for the feedback.

Could you please answer my other question please.


how-to-find-blank-cells-in-a-range-and-the-get-reference-to-them

 

[Fluff]

Please do not make posts asking members to help in other threads. Thanks