2 Replies Latest reply on Aug 7, 2017 10:55 AM by Alex Martino

    How to create diagnols

    Alex Martino

      I have contracts with start dates on rows and end dates on columns. For each month, I created a date difference formula in order to standardize all the differences. For example, if contract start date was January and finish was January then the date difference result is 1 (i added +1 at end of formula). So I can quickly see patterns in terms of start/finish dates for different start date sets.

       

      HOWEVER, now I want to look at a specific end date month and grab all the start date months related to that end month? How can I write a formula to do that? For example, June 2015, is the intersection of customers from 12 months (or more) at various stages of start dates.