Countifs between two dates is not returning the correct figure

[kylerisi]

I have the following formula that counts all the instances where the number in A14 (0) appears in the J:J range which sits between the two dates in D1 (01/03/2020) & D2 (31/03/2020)

The expected figure is 354, however the computed figure is 345. Can anyone help explain why this may be?

=COUNTIFS('URS (Whole Network)'!$J:$J,">="&D$1,'URS (Whole Network)'!$J:$J,"<="&D$2,'URS (Whole Network)'!$K:$K,Dashboard!$A14)

Any help would be highly appreciated.

 

[jasonb75]

Are they just dates, or dates and times in the same cell? Even if the times are hidden by formatting, the formula will still consider them so anything other than midnight will be missed.

See if this gives the correct result.

=COUNTIFS('URS (Whole Network)'!$J:$J,">="&D$1,'URS (Whole Network)'!$J:$J,"<"&(D$2+1),'URS (Whole Network)'!$K:$K,Dashboard!$A14)

 

[kylerisi]

Are they just dates, or dates and times in the same cell? Even if the times are hidden by formatting, the formula will still consider them so anything other than midnight will be missed.

See if this gives the correct result.

=COUNTIFS('URS (Whole Network)'!$J:$J,">="&D$1,'URS (Whole Network)'!$J:$J,"<"&(D$2+1),'URS (Whole Network)'!$K:$K,Dashboard!$A14)

Jasonb75, yes you are correct they include dates and times - and YES your formula works, thank you so much