When I am going through tapes I often verify the number of payments remaining before maturity, and also look at the number of payments the loan is behind. Doing this is pretty straightforward. Many people don’t realize that if you subtract two dates in Excel, it returns the number of days between the dates. Then you can convert the number of days into the number of months. I use this all of the time to calculate data on the tape that isn’t given, and to verify some of the data that is. In this short 5 minute video I run through the details:
Calculating Number of Months Between 2 Dates in Excel
If you have something in particular you are struggling with in Excel and would like me to do a video on it, please reach out and let me know.