5 Replies Latest reply on Aug 25, 2016 10:58 AM by Yuriy Fal

    Normalize Data Around Date

    Caleb King

      Hi,

       

      I am attempting to normalize data around a conversion date to determine the effectiveness of the conversion on KPIs. The normalized date range would be 3 months prior and 3 months post the conversion date. I have read multiple things about the DATEDIFF() and INDEX() functions but can't seem to get them to work with my dataset.

       

      Conversion Date would be Month 0 with the 3 months prior being Month -3, Month -2, Month -1 and months post would be Month 1, etc.

       

      Any advice would be helpful. I have attached the workbook below.