1 Reply Latest reply on Jul 26, 2018 11:10 AM by patrick.byrne.0

    Split data daywise

    Debayan Roy

      Hi All,


      I would like a have a simple solution for the problems attached. In the first Excel tab (Input), I have start date and end date of events (eg A,B). And in the second tab (Desired_Output), Duration of each day of these events has been shown. I just have provided an example set, but practically the data is spreaded over more the 3 days. I was trying to do some calculation like DATEDIFF but seems like pivoting all of the dates is bit difficult.


      Please let me know any further clarification is needed.


      Thanks a lot for your help,