Recurring Formula Issue - CountIFS

[Oranjin]

Hello,

I have the following formula. It is not giving me the correct value, but I have no reason to believe that the way I have entered the formula is incorrect. What this formula is doing is counting some time frames that it shouldn't. For example, in the below formula I have reason to believe it is counting occurences in December of 2015 as well.

I can get around it for now, but it would be nice to get the formula working as it should be.

=COUNTIFS(N14:N2014,">=12/1/2016 0:00",N14:N2014,"<=12/30/2016 23:59")

 

[Marcílio_Lobão]

Oranjin, Good afternoon.

Your formula is correct!

"...For example, in the below formula I have reason to believe it is counting occurences in December of 2015 as well...."
It's not possible.

Are you sure all your date cells are formatted as date?

Try to make this formula works in a small range where you know exactly the result.
Did it work well?

Probably something strange in your cells containing dates.