I am working on a generic mortgage worksheet that I will include in other real estate-related worksheets. However, I've hit a wall with a particular formula. Basically, I want to figure out how to determine how many years and months remain on a loan. I have attached my spreadsheet with the problem notated in cell L2. THANKS for your help!
56.8 KB Views: 6