Hi
I was wondering if there is an Excel formula that can calculate the number of payments remaining on a loan
For example if a loan had a maturity date of say 16/01/2024 (which means payments are due on the 16th of each month)
And we used todays date 4/11/2022
I have been using the DatedIF function but that is not quite accurate as it only totals complete months
I would be most grateful for any guidance that can be provided
Regards
Bruce