Countifs - Dates greater than.

Hello all,

Not sure why this is not working. I have dates in column A and column B. I would like to countifs (there are other criteria's that i won't get into) all the dates that are greater then 2 days apart.

For example:

Column A Column B
15-Jan 16-Jan
15-Jan 18-Jan
16-Jan 16-Jan
16-Jan 25-Jan
17-Jan 10-Feb
17-Jan 18-Jan

=COUNTIFS(A$2:A$10,">"&B$2:B$10+2)

but i'm getting the value of 6 when i should get the value of 3.

What am i missing?

Thanks!

Why not add a column to the data and put;

=IF(B2-A2>2,">2 Days","<2 Days")

Then change your COUNTIFS Criteria to look for the outcome of said formula

Originally Posted by Joe Bushfield

Why not add a column to the data and put;

=IF(B2-A2>2,">2 Days","<2 Days")

Then change your COUNTIFS Criteria to look for the outcome of said formula

Hi Joe, actually i used to have "helper columns" but it's a metric that i don't need and i'm trying to consolidate my data to fewer columns. If this is not achievable then i would not press it and leave the extra column but i'm just not sure what is wrong with my current formula.

Try,

=SUMPRODUCT(--(($B$2:$B$10-$A$2:$A$10)>2))

Thanks all, because of all the other varibles that i need to countifs i think i'll just stick with the helper column. Thanks all for the help!