Counting frequency of dates based on difference between 2 dates

[Zedrick13]

Hi, everyone. Can anybody help me with the formula for counting frequency of dates based on difference between 2 dates?
Here's an example of what I am trying to do:

ColA ColB Freq of <3 days Freq of >5 days
Row1 09/30/18 10/20/18
Row2 09/30/18 10/03/18
Row3 09/25/18 09/27/18

Thanks!

 

[James006]

Hello,

You could test following array formula :

=SUM(IF((B2:B4)-(A2:A4)<3,1))

Instead of the Enter key ...use simultaneously the three keys : Control Shift Enter

HTH