I have a spreadsheet with a list of loans. I want to calculate the number of months that a loan interest payment is late if it's not yet reached maturity, or the number of months interest was unpaid if the maturity date has already passed. And, if there's nothing late, then leave the cell empty.
My spreadsheet has 3 dates: today's date, the date of the first missed interest payment and the maturity date of the loan. Also, have column that is X'd if a loan is late.
So, for example, if a payment is late and today's date is earlier than maturity date, then show number of months between today's date and the month of the first missed payment.
And, if a payment is late and today's date is past the maturity date, then show the number months between the maturity date and the month of the first missed payment.
Leave blank all loans that are current.
I've been playing with IF, AND for a couple of days. I'm stuck.
Thank you in advance for any help. Much appreciated.
My spreadsheet has 3 dates: today's date, the date of the first missed interest payment and the maturity date of the loan. Also, have column that is X'd if a loan is late.
So, for example, if a payment is late and today's date is earlier than maturity date, then show number of months between today's date and the month of the first missed payment.
And, if a payment is late and today's date is past the maturity date, then show the number months between the maturity date and the month of the first missed payment.
Leave blank all loans that are current.
I've been playing with IF, AND for a couple of days. I'm stuck.
Thank you in advance for any help. Much appreciated.