3 Replies Latest reply on Nov 23, 2016 7:43 AM by sirajmandayippurath Branched from an earlier discussion.

    Help to get complicated date calculation

    MichaelH H

      Thank you very much Shawn, could you please open the excel file it has some complicated calculations I really need to get done example below:

       

      if Count Date is blank and Pending = 4 then Today's Date + Days Interval

      but if Count Date > 1 or Pending = 3 or Pending = 2 or Pending = 1 and also if Count Date > 1 and Pending = 3 then Today's Date + Days Interval

      but if Count Date > 1 or Pending = 2 or Pending = 1 and also if Count Date > 1 and Pending = 2 then Today's Date + Days Interval

      but if Count Date > 1 or Pending = 1 or Pending = 0 and also if Count Date > 1 and Pending = 1 then Today's Date + Days Interval

      and lastly if Count Date > 1 or Pending = 0 then the field will be blank or no date

       

      Thanks again,

      Michael