Hello,

I have a question here. I am trying to create formula to include 3 criterias.
Col A = Due Date (Range name: DueDate)
Col B = Status (Range name:Status)
Col C = Date of payment (Range name: PaymentDate)

My aim is to change the status from Due for payment / Outstanding to Paid if some dates have been included in Column C

Currently I only managed to change the Status to Due for payment or outstanding by using IF formula in Col B =IF(TODAY()>DueDate,"Due for payment","Outstanding")

Can anyone help me to incorporate the third criteria into the formula such that if Payment date is not blank, meaning PAID, the paid status is reflected under col B, if it's not paid (blank in Payment Date), it will still reflect due for payment if today date is greater than due date, and outstanding if the today date is smaller than the due date.

Thank you.