I have data on projects that is structured such that each has project has a single record with beginning and ending date fields. What I want to calculate is for every date, how many projects are active on that date. My eventual goal is calculate the average number of daily active projects per month.Equivalently, I could calculate the number of project-days in the month.
Because of other measures that I am calculating using the same data, I would greatly prefer not to have to reshape the data.
I have included a very simple workbook that has some test data with dates. For now, I have just calculated the number of projects which started ended as a function of date. Again, what I need is the number of open projects on each date, and/or the number of projects-days in each month.