Count the Number of Whole Months between Two Dates

To count the number of whole months between two dates, you use the Month Difference function. This calculation includes only one endpoint.

For example:

the number of monthly repayments remaining = MonthDifference(2018-01-15, the final payment due date)

If the final payment due date is 2019-10-18, the number of monthly repayments remaining is 21.

Note: The order of the two dates in the function does not affect the result.