Accounts receivable aging formula

[Closed]
Report
Posts
1
Registration date
Wednesday September 7, 2016
Status
Member
Last seen
September 8, 2016
-
I need help with accounts receivable aging formula.

A1 IS TODAY'S DATE
G4 IS BILLING DUE DATE
H4 IS PAYMENT RECEIVED
I4 IS DATE RECEIVED
K4 IS AGING

Our billing is due within 45 days
i would like K4 to show me how many days have passed since G4
and blank if bill has been paid by G4