0 Replies Latest reply on Jun 5, 2014 9:07 AM by Craig Rudick

    How to get daily count from beginning and ending dates

    Craig Rudick

      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.

       

      Thanks in advance!

      Craig