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

# Help to get complicated date calculation

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

• ###### 2. Re: Help to get complicated date calculation

Where can I find packaged workbook or excel file?

Thanks,

Shin

• ###### 3. Re: Help to get complicated date calculation

Would you have a sample file that you can share? Or maybe even make up a few rows so that we can build and test the logic?

Cheers

Siraj