View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!