ExcelBanter - Excel Loan Ammortation Spreadsheet

I read your other post also with simillar question.
I just thought of a formula.
Now Assume that the Last Paid Date is in Cell A2.
Then in Cell B2 put the frequency of payment in number of days ( e.g., 7,
or 15, or 30 etc. ),
From column C onwarard, first change the Cell format to Date.
And then copy the bellow formula in C2. C2 will give you the next date when
payment is due. Then copy the formula accroos the same row in further
subsequent column, say up to next 11 column. This will give you the dates
next payment due for 1 year.
You copy formula to 24, 36 or what ever number you linke to make it to show
next 2 years date, 3 years date and so on.

Formula to copy in C2:

=OFFSET(C2,0,(-1*COLUMN()+1))+(OFFSET(C2,0,(-1*COLUMN()+2))*(COLUMN()-2))
Sharad

Note: The limitation of my above formula is that it calculates purely by
number of days entered, irrespective of
how many days are in a month.

"ghutchn" wrote in message
...
I would like to download an Excel Loan Ammortation Spreadsheet that I could
learn more about Excel. If that is not feasible, then I'd like to know
the
Date format or formula to make Excel generate the dates for monthly
payment
rows. Also, what is used to list dates automatically in weekly, biweekly
and
annually?

I thank you very much,