3 Replies Latest reply on Sep 6, 2018 7:31 AM by Soham Wadekar

    Getting the last date of the contract based on start date and length of contract

    Imran Azam

      HI Guys

       

      i am creating a report and need to find the contract end date based on the start date and length of the contract (in months).

       

      For example i have two dates in my attached workbook

       

      date: 25/07/2017  Length: 12   i need to return the end date here of 31/05/2018

      date: 02/03/2018  Length 2     i need to return the end date here as 30/04/2018

       

      can this be done?

       

      i have attached an example