4 Replies Latest reply on Nov 29, 2018 2:03 AM by Peter Cox

    Combine two date fields in one table

    Peter Cox

      I have a dataset with subcribers. Each row represents a subscriber including the start date of the subscription, and if cancelled, the cancellation date of the subscription. What I would like to have as output is the net subscription growth per day, so the COUNT of the "Created date" -/- the COUNT of the "Cancelled date" as mentioned in the 2nd tab 'output' in the attached Excel sheet.

       

      I was able to create one sheet with only the new subscriptions per day, and the same for the cancellations, but not to combine these two sheets into one table. I did not find an article yet how to deal with this one.

       

      Can someone help me with this? Many thanks for your help