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
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!

Resources