Forum Discussion
Excel Sum Product / Date Range
I'm using the formula below to count the number of occurrences between the range of dates. =SUMPRODUCT((A2:A317>=DATEVALUE("7/1/2019"))*(A2:A317<=DATEVALUE("6/20/2020"))) =SUMPRODUCT((B2:B317>=DAT...
In addition, I'd do not recommend to use in formulas components like DATEVALUE("7/1/2019"). It's always better to keep all parameters, as dates in this case, in separate cells. Even if hardcode within the formula it's better to use DATE(2019,7,1). DATEVALUE with the text as above could not work in international environment.