How can I calculate the number of days past due based on the date paid and invoice due date?

[Pancakey]

Hello,
I am trying to figure out how I can calculate the number of days the invoice remains outstanding until paid.

So column G is supposed to show how many days have passed since the invoice date. This number will continue to increase until column J is marked as paid. We can use column I or column J to determine when the days stop counting. Is there a formula I can use to get the desired result?

Thank you in advanced!

 

[kevin9999]

Book1
	E	F	G	H	I	J
1	Invoice Date	Invoice due date	Days exceeded	Invoice Total	Payment Date	Paid
2	9/20/2023	9/20/2023	0	$ 630.00	9/27/2023	Paid
3	9/19/2023	9/19/2023	9	$ 2,695.03		Unpaid
Sheet1

Cell Formulas
Range	Formula
G2:G3	G2	=IF(J2<>"Paid",TODAY()-F2,0)

 

[Fluff]

Hi & welcome to MrExcel.
Is this question for Excel or Google Sheets?

 

[Pancakey]

Hello! Thank you.

I am working off both Excel and Google sheets. I imagine both of them would work similarly.
Sorry I realized I shared a screenshot of my google sheet.

 

[Pancakey]

Book1
	E	F	G	H	I	J
1	Invoice Date	Invoice due date	Days exceeded	Invoice Total	Payment Date	Paid
2	9/20/2023	9/20/2023	0	$ 630.00	9/27/2023	Paid
3	9/19/2023	9/19/2023	9	$ 2,695.03		Unpaid
Sheet1

Cell Formulas
Range	Formula
G2:G3	G2	=IF(J2<>"Paid",TODAY()-F2,0)

Thank yooou so much!! This worked for me. I have been trying to figure out which formulas to use to get the expected results.

 

[kevin9999]

Thank yooou so much!! This worked for me. I have been trying to figure out which formulas to use to get the expected results.

Happy to help & thanks for the feedback