I am on the board of charity that does micro loans in Africa and we used excel sheet to keep track of loan repayments. I would like to find the date of the last payment. Column A has the date and Column C has the payment. All the payment cells are pre filled with zeros. I think a CSE formula could be used but I have not been able to find the right formula to do this. I am hoping some here can help me write the correct formula. Below is an example of that a repayment sheet would look like. In this example I would like to have a formula that would return the date of 23-Dec-14 as that was the date of the last payment as shown in Column C. A B C D E F G H 1 Payment Date Weekly Amt Payment Past Due Paid to Date Loan Balance Savings Saving Bal 2 2-Dec-14 19,300 38,600 0 38,600 461,400 0 0 3 9-Dec-14 19,300 10,000 9,300 48,600 451,400 0 0 4 16-Dec-14 19,300 0 28,600 48,600 451,400 0 0 5 23-Dec-14 19,300 15,000 47,900 48,600 451,400 0 0 6 30-Dec-14 19,300 0 67,200 48,600 451,400 0 0 I hope someone can help me with this. Doug
This question generated 16 answers. To proceed to the answers, click here.
This thread is current as of October 18, 2015.