Forum Discussion
Solved
Need to graph records that fall between a start and end date over time
I have a data set where each record (case) has a start date (column B) and an end date (column D). I want to know how many records (cases) were active in any given month so that I can chart active c...
Sergei switched the conditions. Here is a sample workbook with my formula and the corrected version of Sergei's formula.
If you have month as the date entered in any cell, e.g. H1 and formatted as mmm-yy or so, you may use
=COUNTIFS(B:B, ">"&EOMONTH(H1,-1), D:D, "<="&EOMONTH(H1,0))
It just returns a zero, every COUNTIFS function I've tried just returns a zero.