Excel Magic Trick 1166

Count Dates From Date-Time Values: COUNTIFS or PivotTable?

DESCRIPTION

See how to Count Dates From Date-Time Values: COUNTIFS or PivotTable:
(00:00) Look back to EMT 1163 to look at SUMPRODUCT and INT formula
(00:45) COUNTIFS formula with 2 Criteria. Faster Calculating than SUMPRODUCT and INT Formula
(03:18) Pivot Table method is faster to create.
(04:40) Time Formulas: [1] COUNTIFS and [2] SUMPRODUCT & INT