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")
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")