Due date calculation

I am facing problem in calculating overdue days based on due date minus payment received date. If settelment is equal to 0 then next due date.

Please help.

Sheet is attached for better understanding.

Hi Welcome to forum,
What is your expected result can you please explain more your requirement.

Try I2...
=IFERROR(VLOOKUP("PAYMENT RECEIVED",D2:E2,2,FALSE)-IF(H$2:H2>0,LOOKUP(2,1/("INVOICE"=D$2:D2),E$2:E2),E2:E2),"")
Copy down

THIS FORMULA IS CALCULATING OVERDUE DAYS FROM 1st,2nd... SO ON INVOICE DATES, BUT I WANT IT TO CALCULATE FROM NEXT INVOICE DATE AS SOON AS CELL IN SETTELMENT COLUMN = 0.

Can anyone solve my problem related to calculating overdue days in the attached excel sheet 3.

I want overdue days to be payment received date - invoice date, if settelment amount is > o or payment received date - next invoice date if sattelment amount is =0.

Originally Posted by Phuocam

Try I2...
=IFERROR(VLOOKUP("PAYMENT RECEIVED",D2:E2,2,FALSE)-IF(H$2:H2>0,LOOKUP(2,1/("INVOICE"=D$2:D2),E$2:E2),E2:E2),"")
Copy down

THIS FORMULA IS CALCULATING OVERDUE DAYS FROM 1st then 2nd... INVOICE DATES, BUT I WANT IT TO CALCULATE FROM NEXT INVOICE DATE AS SOON AS CELL IN SETTELMENT COLUMN = 0.

Originally Posted by shukla.ankur281190

Hi Welcome to forum,
What is your expected result can you please explain more your requirement.

I want overdue days to be, "payment received date" - "invoice date", if settelment amount is > 0 or "payment received date" - "next invoice date" if sattelment amount is = 0.

I have made some correction in the sheet. Please refer to it for better understanding.

I am trying formula

=iferror(vlookup("payment received",b3:c3,2,false)-index(e$2:e3,match("satteled",i$2:i3,0)),"")

in column i of the sheet but could not get it right.
Please help

sheet is attached with this change.

Please find attached sheet with desired result column.