8 Replies Latest reply on Jun 27, 2016 1:23 PM by Saurabh Siroya

    Spread value between start date and end date

    Lucas Batt

      Hi,

       

      I would like to spread the "days spent fishing" value between the "trip start date" and the "trip end date" to show the average days spent fishing for that trip.

       

           

      Trip nameTrip Start dateTrip End DateDays spent fishingAverage days spent fishing
      Belize23/10/1228/11/12260.722222222
      Mexico25/10/1217/12/12270.509433962
      Uruguay14/12/1213/01/13120.4
      **formula**

      =D4/(C4-B4)

       

      Any ideas?