6 Replies Latest reply on Dec 11, 2016 7:24 AM by John Croft

    Date Difference

    Arihant Jain

      Hello,

      I have data set as per below table, where by Receipt data do have few missing value.

       

      I want to use a formula where by-

                If receipt data is Missing then "No Receipt"

                else today()-receipt date

       

      Also based on the days, calculated by above formula I want to create a aging as per below

                IF [Receipt Aged]="No Receipt" THEN "No receipt"

                ELSEIF  [Receipt Aged]<10 THEN "Less than 10 Days"

                ELSEIF [Receipt Aged]<51 THEN "10-50 Days"

                ELSEIF [Receipt Aged]<81 THEN "51-80 Days"

                ELSEIF [Receipt Aged]<101 THEN "81-100 Days"

                ELSEIF [Receipt Aged]<151 THEN "101-150 Days"

                ELSEIF [Receipt Aged]<201 THEN "151-200 Days"

                ELSE "Above 200 Days"

                END

      I am not able to get the formula correct. Please help

      Receipt Date
      PO Date
      10/23/201610/23/2016
      10/11/2016
      10/01/2016
      11/01/201611/01/2016

       

      Thanks

      Arihant Jain