5 Replies Latest reply on Aug 6, 2018 2:44 PM by Deepak Rai

    Help Needed: 1 filter for 2 Date Fields

    Samuel Foshay

      Hi all,

       

      working with call center case data. I need to have one date filter (adjustable to any range) effect data so I can return the number of cases opened and closed within a certain set of dates. so between 2/1 and 3/1 we opened 2 cases and closed 3.

       

      Date Open Date Closed
      ID
      2/12/51
      1/12/101
      2/34/11
      1/152/151

       

      How would I organize my Sheet in a dynamic way to achieve this?

       

      SF