Formula for Monthly Increments

  • Thread starter Thread starter Reagan Fruth
  • Start date Start date
R

Reagan Fruth

Does anyone know of a formula to return accurate monthly increments
for amortization purposes? For example if the start of a loan is
8/1/03, I want the next row to output 9/1/03 and the next row to
output 10/1/03, etc. The problem I am having is with the various
months with a different amount of days in them.
 
With 8/1/03 in A1, enter the following in A2:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

The only "problems" that will occur happen when your start date is on the
29, 30, or 31, which some months do not have.
 
Back
Top