3 Replies Latest reply: Feb 21, 2017 2:04 PM by swana woo RSS

    calculate the time gap between the dates group by another dimension

    swana woo
      NameDateEventTime Gap
      A04/01/2012TEXT
      A03/05/2013TEXT
      A04/12/2013TEXT*
      B01/01/2016TEXT
      C09/27/2015TEXT
      C10/04/2017TEXT

       

      I want to calculate the time gap between the dates by Name.

      for * marked cell, fill the cell with the number value(number of days difference between 04/12/2013 and 03/05/2013).

      for Name B, there is just one date value, so just leave it Time Gap cell as '-'

       

      Could anybody help me??