Days accrued for late payment calculation.

asked 2018-09-14 20:04:31 +0100

I have a start date for when the payment is due that is calculated, so it is not in text format. I enter the date the payment was deposited (in text format). If the paid date is more than 5 days past the due date I need to apply a late fee, and deduct that amount from the deposited amount.

I have spent two days trying to accomplish this simple task. my Excel experiance has not been much help. Can someone pleas give me a hand.

edit retag flag offensive close merge delete