Excel Tips and Tricks - Calculate the next period for your payment
MS Excel users often need to calculate a series of payments that occur at regular intervals based on specific dates.
This spreadsheet can help Excel users calculate series of periodic payments based on dates, such as mortgage periods, pay periods, and more, for various frequencies including weekly, bi-weekly, semi-monthly, monthly,