3 Replies Latest reply on Mar 19, 2015 7:26 AM by kettan

    Measure activity between dates

    Peter Lalvani

      Hello,

       

      I would like to measure (count) the amount of activity, in this case running projects, between a start and end date.

       

      Therefore, from the attached workbook, I want to end up with something like this:

       

      ref date          running projects

      01/011999      10

      01/01/2000     20

      01/01/2001     30

      01/01/2002     40

       

      I have tried to join a separate reference date with which to compare the start and end dates e.g.

       

      if [Start date]<[ref date] and [end date]>[ref date] then project is running at the ref date

       

      However iI have been unable to execute this join...

       

      I hope this is clear and thanks for any tips

       

      Pete