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.
It did work, I had to tweak it (it was a lot of data). Now I have a new problem...
A case that has no end date must also be counted, how do I do that?
A case that has no end date must also be counted, how do I do that?
Here is a new version.