Formula for Monthly Increments

[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.

 

[Laura Cook]

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.