count between dates with two criteria

[pelonsoncio]

Hi,

I need a formula that will allow me to count the number of account Approved or Active between a date range

A B
Active 1/01/19
Approved 1/19/19
Active 2/10/19
Pending 2/20/19
Close 3/15/19

Thanks,
Carlos

 

[lrobbo314]

Try this.

=SUMPRODUCT((((A1:A5="Active")+(A1:A5="Approved")))*((B1:B5>=DATE(2019,1,18))*(B1:B5<=DATE(2019,2,10))))