Recurring monthly payment
If you want to generate a list of dates one month apart, then first enter the
staring date in A1:
8/27/2006
and then in A2 enter:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) and copy this down the column.
--
Gary's Student
"Dr. Zhivago" wrote:
I posted this once today already, but I can't find my original question
anywhere!
I need a formula which will enter a loan payment on the same date each month
over a 30-year period. I have a long spreadsheet which calculates the
interest on a daily compound basis, using one row for each day. This needs
to take into account months with 28/30/31 days, and also leap years.
Any help will be much appreciated!
|