Forum Discussion

Aidan1700's avatar
Aidan1700
Copper Contributor
Jul 22, 2020
Solved

Past Due Date Calculation based upon Status

I thought this would be a pretty easy statement to write, however I'm struggling more then I thought I would with it.    I want to calculate Date Past Due days based upon an Expired status in a col...
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 22, 2020

Aidan1700 

 

Maybe this could fit.
Please see the attached file.

If this is the answer, please tick the correct answer and a like ... if not, please give a short feedback.

 

Nikolino

I know I don't know anything (Socrates)

  • Aidan1700's avatar
    Aidan1700
    Copper Contributor
    Jul 22, 2020

    NikolinoDE 

    Thank you Nikolino, I appreciate your help.

     

    It only answers the question partially. I need to control it by the status "expired" and if the status "closed" I don't want it to recalculate.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 22, 2020

      Aidan1700 

      Perhaps

      with

      =IF(C6="Closed",MAX(0,Q6-P6),IF(C6="Expired",MAX(0,TODAY()-P6),""))
      • Aidan1700's avatar
        Aidan1700
        Copper Contributor
        Jul 22, 2020

        SergeiBaklan Thanks so very much, you are like a magician!

    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Jul 22, 2020
      in a small sheet with the desired values and the output would be an advantage ... especially for those who can not handle english as well as some ignorant like me 🙂

Resources