3 Replies Latest reply on Jun 30, 2012 9:42 AM by Joe Mako

    Count of items between two dates, by date

    Kester Harding

      OK, I’m not sure that title is clear and that might be why I’ve not managed to find a previous discussion on this by searching. If it has been discussed before my apologies, please point me in the direction of thread.

       

      What I am trying to do is plot file handlers case loads over a period of times. I have a list of cases with the references, the file handler, the date it was allocated and the date it was concluded (if it is not still active.) So my x-axis is date, say at week level, and for each week I want the count of cases where the date allocated <= that week and the date concluded is null or > that week. Can anyone think of a way to do this?


      I’ve produced some dummy data to work with but I haven’t built anything in the attached packaged workbook because I’m not sure how to begin!

       

      Thanks

       

      Kes