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.
I'm running into another issue, the data is over multiple years so that solution is counting everything. I added a file so you can see the actual data set. Thank you.
- Can you Please help me with the same version to exclude blank start date and end dates
- Thank You So Much!
