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.
I tried entered your solution exactly as stated, it also returns nothing but zero.
Sergei switched the conditions. Here is a sample workbook with my formula and the corrected version of Sergei's formula.