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

    Measure activity between dates

    Peter Lalvani



      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