5 Replies Latest reply on Dec 6, 2018 5:11 AM by Zhouyi Zhang

    Showing record that fall within a period of time -

    Rakesh Khoodeeram

      Hello,

       

      I am trying to plot a line chart to display staff leaves over one year.

      I have attached a sample Excel sheet.

       

      I have looked at the following post : Showing record that fall within a period of time - troubleshooting

      It does not fit my needs since it does not cater for multiple occurrence of a client.

       

      What I want to display is, the number of staff on leaves per month.

      example:

      StaffOpen DateClose DateNumber Of DaysDescription
      D31/12/201303/02/2014351 day in December, 31 days in January and 3 days in February
      E21/11/201402/12/20141210 days in November and 2 days in December

       

      So, for

      November: 1 staff

      December: 2 staff

      January: 1 staff

      February: 1 staff

       

      Thanks for any solution/tutorials.